Opening an xlt-file as an xls-file

[Whitestar]

Is that possible?

When I use Workbooks.Open it opens as an xlt-file. But I want to open it as a new xls-file based on the xlt-template.

[NickHK]

Whitestar,
Using Excel 2000 and :
Application.Workbooks.Open PathToTemplateFolder & MyXLTTemplate

gives me an .xls file.

What's your code ?

NickHK

"Whitestar" <[email protected]> wrote
in message news:[email protected]...
>
> Is that possible?
>
> When I use Workbooks.Open it opens as an xlt-file. But I want to open
> it as a new xls-file based on the xlt-template.
>
>
> --
> Whitestar
> ------------------------------------------------------------------------
> Whitestar's Profile:
http://www.excelforum.com/member.php...o&userid=28253
> View this thread: http://www.excelforum.com/showthread...hreadid=478163
>

[Whitestar]

Thanks for replying NickHK

I found it out. Incredible what can be accomplished by reading the help. ;-)

In Excel 2003 i wrote:
Workbooks.Open Filename:= "c:\temp\testfile.xlt", Editable:=False

The "Editable:=False" bit did the trick :-)

[Dave Peterson]

Or even:

workbooks.Add template:="c:\temp\testfile.xlt"



Whitestar wrote:
>
> Thanks for replying NickHK
>
> I found it out. Incredible what can be accomplished by reading the
> help. ;-)
>
> In Excel 2003 i wrote:
> Workbooks.Open Filename:= "c:\temp\testfile.xlt", Editable:=False
>
> The "Editable:=False" bit did the trick :-)
>
> --
> Whitestar
> ------------------------------------------------------------------------
> Whitestar's Profile: http://www.excelforum.com/member.php...o&userid=28253
> View this thread: http://www.excelforum.com/showthread...hreadid=478163

--

Dave Peterson