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.

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.

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.