How to open xl and create a new document based on a template

C

Colin Wilson

does anyone know if there is an xl equiv to the word macro "Documents.Add
Template etc, to open a new xls from an xlt - I want to be able to open and
save new xls's without changing the template..
 
B

bigwheel

Take a look at "Add Method (Workbooks Collection)" in the helpfile. You'll
see that you can specify the template name to be used to create new workbooks
i.e.

Workbooks.Add(Template:= "C:\template.xlt")
 
E

epost2

Do you mean like

Sub openfromXLT()
Workbooks.Add Template:="my_xltpath"
End Sub

Have you tried to record this action?
 
Top