Save sheet as? Thanks Jay!

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

Quote:

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

Tom Schreiner · Apr 6th, 2002, 06:27 PM

Thanks Jay!
Is what I needed!
Tom

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 6th, 2002, 05:35 PM	#1
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	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 ]

Apr 6th, 2002, 06:27 PM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Thanks Jay! Is what I needed! Tom