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,
Using Excel 2000 and :
Application.Workbooks.Open PathToTemplateFolder & MyXLTTemplate

gives me an .xls file.

What's your code ?

NickHK

"Whitestar" wrote
in message ...

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

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

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