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

On Tue, 25 Jul 2006 06:31:02 -0700, Khoa <Khoa@discussions.microsoft.com> 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.

[Khoa]

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 <Khoa@discussions.microsoft.com> 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.
>
>