How to copy a workbook
I need to know how to copy a workbook in a macro (Excel 2002)
The filename of the workbook to be copied is "Template" (w/o quotes)
The new workbook will have the name of an employee, ie several workbooks,
each having the name of an employee.
Variable: EMP = "John Doe"
Code needed to copy workbook TEMPLATE and rename to variable EMP.
Thanks,
Les
|