Macro-enabled Template for 2007 must be saved as *.xltm

From help on "file type"

XML file type Extension
Workbook .xlsx
Macro-enabled workbook .xlsm
Template .xltx
Macro-enabled template .xltm
Non-XML binary workbook .xlsb
Macro-enabled add-in .xlam



Gord Dibben MS Excel MVP

On Sun, 6 Dec 2009 06:32:39 -0800 (PST), Andrew
wrote:

On Dec 5, 10:42*am, "Otto Moehrbach"
wrote:
Any version of Excel including 2007
I wrote a VBA project for an OP and he saved it as a template (xlt). *When
the code opened that file and placed data into it and saved it as an xls, he
found that it was missing some of the standard modules. *Is that related in
any way to the xlt thing?
A related question: *What is the benefit of making a file an xlt file? *I
realize that you don't want to change the original xlt file, but if the code
opens that file, changes it, and then savesAS another xls name, does it make
any difference if the original is an xlt or xls? *Thanks for your time to
educate me a bit. *Otto

I have had a great deal of trouble in trying to use my VBA projects
(written with Excel 2003) in Excel 2007. I have found that Excel 2007
erases all of my code. I have been trying to run a project as an xlt,
which opens and saves to an xls file. I have not yet been able to do
it.