Here is the code that I use to opne a template called "TreeTemplate.xls". I
keep the template in the same folder as the workbook that calls the code.
The xls file should be closed when the cjode is run.

strCurrentExcelPath = ActiveWorkbook.Path 'assign path information

Workbooks.Open Filename:= _
strCurrentExcelPath & "\TreeTemplate.xlt", Editable:=True
'open template for new file

Stan Shoemaker
Palo Alto, CA

"IXLINXL" wrote:

I am using the office 2000 package. Can anyone tell me how I can open a .xlt
file via code? The methods I have tried all seem to open the .xlt and an
instance of itself and open up as a .xls file?

BTW I have posted a similar question on another newsgroup(with no luck so
far). As soon as I get find a solution I will be sure to update both groups
as to avoid potentially duplicate efforts.

Thanks,

IXLINXL - not