Opening an xlt-file as an xls-file
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 |
Opening an xlt-file as an xls-file
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 |
Opening an xlt-file as an xls-file
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 |
Opening an xlt-file as an xls-file
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 |
All times are GMT +1. The time now is 09:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com