Open XLS as though an XLT - unsaved copy in memory
 

Using Office 2003 and Windows XP;

Call me lazy; is there a way to open an unsaved copy of a normal XLS in
memory as though it were a template, without having to actually save the XLS
as an XLT?

If this is possible could someone please post generic example VBA or
VBScript to do it?

Thanks much in advance.

Open XLS as though an XLT - unsaved copy in memory
 

Instead of

Workbooks.Open sFileName

use

Workbooks.Add sFileName

the workbook named sFileName will be used as a template, whether or not it
was saved as such.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"XP" wrote in message
...
Using Office 2003 and Windows XP;

Call me lazy; is there a way to open an unsaved copy of a normal XLS in
memory as though it were a template, without having to actually save the
XLS
as an XLT?

If this is possible could someone please post generic example VBA or
VBScript to do it?

Thanks much in advance.