Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLT vs XLS
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLT vs XLS
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLT vs XLS
You can do the same thing with an .xls file, but with the .xlt, it forces
you to create a new file. You cannot inadvertantly save the .xlt file with any changes made, whereas you could with the .xls file, thereby destroying your template. "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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLT vs XLS
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLT vs XLS
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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLT vs XLS
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. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLT vs XLS
That makes good sense. Thanks. Otto
"JLGWhiz" wrote in message ... You can do the same thing with an .xls file, but with the .xlt, it forces you to create a new file. You cannot inadvertantly save the .xlt file with any changes made, whereas you could with the .xls file, thereby destroying your template. "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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
XLT vs XLS
Andrew
You say " 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." What is your code and what happens when you run it? Error message? Provide more info on your problem. Otto "Andrew" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|