Excel Sheets and VB

I am trying to make a time sheet interface. Say 80 names or employee #. The time Sheet will be the same so a template would need to be made, I would then need to Identify each sheet buy the employee name and or #. The employee would enter their name in a text box the name of the employee would then be the name of the sheet. So how do I open a different sheet ( a generic template) for the empoyee as they sign in.

Please Note: I am using VB that came with Office 2000.
Aslo will VB 5.0 Pro work on winXP and can it be upgraded to .net

Thanks

Rob

Quote:

---

Please Note: I am using VB that came with Office 2000.
Aslo will VB 5.0 Pro work on winXP and can it be upgraded to .net

---

Yes vb5 will work with all versions of windows over 3.1, as for the second part here, I don't thik you can upgrade it - vb.net will attempt to install a fresh copy onto your system & run alongside of vb5. I'm not 100% sure on that one though so you might want to double-check this one in the vb.net forum.

You'll want to look up xlt in your helpfiles - if you save a workbook with an xlt extension as opposed to an xls extension in Excel, this is saved as a template file.

The second part there, you could hold the name entered into a public variable, then when you come to save the workbook, you could pass this variable in :

workbooks(1).saveas strPrivateVariable & ".xlt"