It will, but once you haved saved it it contains those changes. It doesn';t
retain the 'template' as a template file does.

"Otto Moehrbach" wrote in message
...
Bob
Thanks for your reply. I understand what you say. My question is, why
wouldn't an xls file do the same thing, that is, open it, SaveAs a new
name? Thanks again. Otto

"Bob Phillips" wrote in message
...
I don't think the fact that it is an xlt is anything to do with the
missing modules.

An xlt file is a template, when you new a file and select that template
it creates a workbbok based upon that template, with all of its fonts,
its setup, and all of the code. The purpose is to create a style of
workbooks easily, having the style already defined.

HTH

Bob

"Otto Moehrbach" wrote in message
...
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