Auto open a .xlt template

[Khoa]

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.

 

[Gord Dibben]

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

 

[Khoa]

Thanks.

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