Excel Sheets and VB

[ramadilljr]

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

[alex_read]

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.

[alex_read]

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"