Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to open xl and create a new document based on a 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.. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to open xl and create a new document based on a 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.. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to open xl and create a new document based on a template
Do you mean like Sub openfromXLT() Workbooks.Add Template:="my_xltpath" End Sub Have you tried to record this action? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i create an automaticly generating number for a document? | Excel Discussion (Misc queries) | |||
Create a report with selected rows based on the content in a cell | New Users to Excel | |||
how to create and use a new spreadsheet based on a template | Excel Discussion (Misc queries) | |||
Template in Excel | New Users to Excel | |||
Create a template for every worksheet | Excel Discussion (Misc queries) |