Opening template.xlt

[Tony Bender]

I am using Excel 2000 and experiencing a problem when I open a
template. In previous versions of Excel when I opened template.xlt it
always opened as a workbook; template1.xls. Now when I open the
template.xlt it opens as such and does not convert to an .xls.

How do I fix this?

Thanks,

Tony

 

[Jim Rech]

I think putting your template in your "templates folder" will address this.

The templates path is returned by the VBA code:

Application.TemplatesPath

And also when you save a workbook as a template Excel defaults to saving in
this folder.

--
Jim Rech
Excel MVP
|I am using Excel 2000 and experiencing a problem when I open a
| template. In previous versions of Excel when I opened template.xlt it
| always opened as a workbook; template1.xls. Now when I open the
| template.xlt it opens as such and does not convert to an .xls.
|
| How do I fix this?
|
| Thanks,
|
| Tony

 

[Tony Bender]

Thanks,

I built a template, saved it as such in the default 'Templates'
folder. However when I open it I still get the original .XLT.

Tony

 

[Dave Peterson]

How are you opening the template?

If File|open, then try File|New...

If you're just double clicking on the file in windows explorer, try this:

Rightclick on the file instead. You should see Open and New.

Which one is bold? If it's Open (for .xlt file types), then
open Windows Explorer

Tools|Folder Options (win98 option--your menu items may vary)
File types tab
Scroll down to MS Excel Worksheet (*.xlt)
Select that one
Click on Edit
In the actions box, highlight New and click "Set Default"
Ok your way out.

 

[Gord Dibben]

Tony

How did you save it?

If you just typed in the extension .XLT, it would still be a regular workbook.

If you scrolled down in File Types to Template(*.xlt) and saved as without an
extension, it would be a Template and should operate properly.

Gord Dibben Excel MVP