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..
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..
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")
"Colin Wilson" wrote:
> 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..
Do you mean like
Sub openfromXLT()
Workbooks.Add Template:="my_xltpath"
End Sub
Have you tried to record this action?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks