Auto open a .xlt template

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Gord Dibben said:
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
Click to expand...
 
Back
Top