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]

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"