Hi Tom,On 2002-04-06 16:35, TsTom wrote:
Hey guys!
I have a workbook with a sheet called Report Template.
I would like for VBA to create a new workbook, with one sheet, using the template from the workbook which created the new workbook.
Report Template is sheet4
Will you help me from here?
Workbooks.Add
?
?
Thanks,
Tom
Try
Sheets("Report Template").Copy
This will copy the sheet to a new workbook.
Regards,
Jay
Like this thread? Share it with others