Open XLS as though an XLT - unsaved copy in memory

[Guest]

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.

 

[Jon Peltier]

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