XLT vs XLS
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
|