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

[Guest]

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..

 

[Guest]

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")

 

[epost2]

Do you mean like

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

Have you tried to record this action?