| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Auto open a .xlt template
I have my own Menu application that I can easily open files or create new
files based on my templates. (I use CDMenuPro to make this). It's easy to make a button that open MSWord, then run a macro at the same time to open a template that I created. But I don't know how to do the same thing in Excel ! I wonder how to write a macro that automatic create a file from a template (xlt ?) when I open Excel, because I want the template to be unchanged. Hope this is clear. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Auto open a .xlt template
To open a Template, which I assume has a template extension of .XLT simply
create a shortcut to it. Excel will open it as a workbook. "C:\Program Files\Microsoft Office\OFFICE11\MyTemplate.xlt" Your path and name to be inserted as above. Gord Dibben MS Excel MVP On Tue, 25 Jul 2006 06:31:02 -0700, Khoa wrote: I have my own Menu application that I can easily open files or create new files based on my templates. (I use CDMenuPro to make this). It's easy to make a button that open MSWord, then run a macro at the same time to open a template that I created. But I don't know how to do the same thing in Excel ! I wonder how to write a macro that automatic create a file from a template (xlt ?) when I open Excel, because I want the template to be unchanged. Hope this is clear. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Auto open a .xlt template
Thanks.
"Gord Dibben" wrote: To open a Template, which I assume has a template extension of .XLT simply create a shortcut to it. Excel will open it as a workbook. "C:\Program Files\Microsoft Office\OFFICE11\MyTemplate.xlt" Your path and name to be inserted as above. Gord Dibben MS Excel MVP On Tue, 25 Jul 2006 06:31:02 -0700, Khoa wrote: I have my own Menu application that I can easily open files or create new files based on my templates. (I use CDMenuPro to make this). It's easy to make a button that open MSWord, then run a macro at the same time to open a template that I created. But I don't know how to do the same thing in Excel ! I wonder how to write a macro that automatic create a file from a template (xlt ?) when I open Excel, because I want the template to be unchanged. Hope this is clear. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cannot open an xl97 file | Excel Discussion (Misc queries) | |||
| How do I remove "cannot open template wizard" msg box? | Excel Discussion (Misc queries) | |||
| Template in Excel | New Users to Excel | |||
| message/dialog box auto open when excel file is activated | Excel Discussion (Misc queries) | |||
| How do I convert cab file to open an Family Budget Excel Template? | Excel Discussion (Misc queries) | |||
Linear Mode
