change .xlt to .xls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a template and saved it with the extension .xlt

When I save my new workbooks using the template it retains the .xlt entension. What code should I write to take care of this problem

Thank you in advance for your help
ML
 
What do you mean by code, are you automating this using a macro?
Otherwise put the template in the template folder and open it as follows,
file>new>template (it can differ depending on the version, in excel 2002
onwards you select from a task pane, in earlier versions I believe you
select within a window that opens), select the template and save as and it
will automatically save as *.xls
it will use the same name and add a number 1 for the first etc just like
Book1, Book2 etc

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom


ML said:
I created a template and saved it with the extension .xlt

When I save my new workbooks using the template it retains the .xlt
Click to expand...
entension. What code should I write to take care of this problem?
 
XL5.0 was the last version where the .xlt extension was *necessary* to
designate a file as a template.
From XL97 on, *where* it was saved was the major compelling influence behind
designating a file as a *true XL template* (opening a copy, not the
original).
Although choosing "Template(*.xlt)" in the "save as type" box, in the
"SaveAs" window,*will* save the file with an .xlt extension *in* the
machines default template folder, saving a regular .xls file to this same
default template folder will do *exactly* the same thing, ... make this .xls
file a *true XL template*.

So, the question is, *where* did you save your .xlt file?
But, if you're using a macro to save, does it really matter, if you can use
a macro to open, and protect the original, having the macro do the job of a
template?
--


Regards,

RD
 
Back
Top