Save sheet as? Thanks Jay!

[Legacy 98055]

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
This message was edited by TsTom on 2002-04-06 17:27

 

[Jay Petrulis]

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

Hi Tom,

Try

Sheets("Report Template").Copy

This will copy the sheet to a new workbook.

Regards,
Jay

 

[Legacy 98055]

Thanks Jay!
Is what I needed!
Tom