how to create a new workbook based on a template...

[jimc]

I would like to create a new workbook based on a template, but not the
xlstart template. In other words I dont want to use a default but be
able to specify the template file when creating the workbook. Is this
possible? Same question with worksheets.

Jim

 

[Vasant Nanavati]

Workbooks.Add sTemplateLocation

where sTemplateLocation is the string pointing to the template address.

______________________________________________________________________

 

[Dave Peterson]

dim wkbk as workbook
set wkbk = Workbooks.Add(template:="C:\my documents\excel\mybook.xlt")

and

Dim wks as object
set wks = sheets.add(Type:="C:\my documents\excel\mysheet.xlt")

 

[jimc]

Thanks you very much

Workbooks.Add sTemplateLocation

where sTemplateLocation is the string pointing to the template address.

______________________________________________________________________