Save sheet as? Thanks Jay!

**Tom Schreiner** · Apr 6th, 2002, 04:35 PM

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** · Apr 6th, 2002, 05:00 PM

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