Sheets("sheet1").Copy

[Little Penny]

Sheets("sheet1").Copy

This line of code copies the sheet1 to a new workbook useing the
default template. Is there a way to put into the code and tell excel
which template to use.

I want to avoid changing everyone default template.

 

[Guest]

What do you mean by default template??? That line of code copies the sheet
with tab name "sheet1" from the active workbook to a new workbook.

 

[Dave Peterson]

I don't understand.

This'll copy that sheet1 to a new workbook--there's no template involved (no
workbook template and no worksheet template).

 

[Guest]

Are you thinking of Word where there is a Normal.dot file. XL has nothing
similar...

 

[Little Penny]

I ceated a excel tempalte the include serveral macro.

I want to be able use

Sheets("sheet1").Copy

But have excel use the template to open the new workbook

 

[Dave Peterson]

Create a new workbook that uses that template.
Copy the worksheet into that workbook.

Dim NewWkbk As Workbook
Dim WksToCopy As Worksheet

Set WksToCopy = ActiveWorkbook.Worksheets("Sheet1")

Set NewWkbk = Workbooks.Add(template:="C:\folder\yourtemplatename.xlt")

WksToCopy.Copy _
before:=NewWkbk.Worksheets(1)