How to open a new XLS based on an XLT?

[Dijital]

I have a template called Test.XLT. I want to be able to open a new workbook using that template. Is there an easy way to do this??

-Jim Connors

 

[arst06d]

set oXL = createobject("Excel.Application&quot
oXL.visible=true
oXL.Workbooks.Add test.xlt

you might need to qualify the path to the template file if you dont save it where Excel expects.

 

[Dijital]

It did not work as such, but adding quotes and the full file path worked like a charm!! Thanks!

Do you know perhaps anywhere that has good documentation on the office (2000 & XP) DOM?

-Jim Connors

 

[arst06d]

We're still way behind with Office 97
I've usually found the on-line help in Excel97 to be OK.
Anything a bit unusual I go surfing.

Cheers.