If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
converting excel 2003 to 2007 file formats
I have macros created in excel 2003 (*.xla) as an add-in and wanted to
upgrade them to excel 2007. Also, there is an excel template (*.xlt) that works in conjunction with these macros. First, I open the files and save as 2007 file formats and trying to get them work. But, it is not working. What should I do? Any suggestions would be greatly appreciated. |
#2
|
|||
|
|||
converting excel 2003 to 2007 file formats
Define "it is not working", that is pretty vague.
XX23 wrote: I have macros created in excel 2003 (*.xla) as an add-in and wanted to upgrade them to excel 2007. Also, there is an excel template (*.xlt) that works in conjunction with these macros. First, I open the files and save as 2007 file formats and trying to get them work. But, it is not working. What should I do? Any suggestions would be greatly appreciated. |
#3
|
|||
|
|||
converting excel 2003 to 2007 file formats
Save the add-in(*.xla) as a 2007 add-in *.xlam if you wish but not really
necessary. Don't know what you mean by a "template that works in conjunction with these macros" Gord Dibben MS Excel MVP On Thu, 22 Oct 2009 11:27:01 -0700, XX23 wrote: I have macros created in excel 2003 (*.xla) as an add-in and wanted to upgrade them to excel 2007. Also, there is an excel template (*.xlt) that works in conjunction with these macros. First, I open the files and save as 2007 file formats and trying to get them work. But, it is not working. What should I do? Any suggestions would be greatly appreciated. |
#4
|
|||
|
|||
converting excel 2003 to 2007 file formats
Yes, it is not working.
First, the add-in file (.xla) have linked to the 2007 ribbon interface and saved as macro-enabled add-in file (.xlam). Now, the problem is with .xlt (template file). I open the .xlt file (2003) and save it as .xltx in the same directory on 2007 (where I used to keep that file in excel 2003 i.e., c\program files\microsoft\templates\other documents). So, when I use the macros (it is several steps) before giving a name for the new worksheet and complete the task. This is where the problem comes and gives an error says that Template not found to complete this macro. It works fine when I leave it as .xlt and saves in the above mentioned folder. It does not work when save as .xltx or .xltm. I have been trying for days. Any suggestions would be greatly appreciated. XX23 "XX23" wrote: I have macros created in excel 2003 (*.xla) as an add-in and wanted to upgrade them to excel 2007. Also, there is an excel template (*.xlt) that works in conjunction with these macros. First, I open the files and save as 2007 file formats and trying to get them work. But, it is not working. What should I do? Any suggestions would be greatly appreciated. |
#5
|
|||
|
|||
converting excel 2003 to 2007 file formats
See Gords reply about the xla file!
XX23 wrote: Yes, it is not working. First, the add-in file (.xla) have linked to the 2007 ribbon interface and saved as macro-enabled add-in file (.xlam). Now, the problem is with .xlt (template file). I open the .xlt file (2003) and save it as .xltx in the same directory on 2007 (where I used to keep that file in excel 2003 i.e., c\program files\microsoft\templates\other documents). So, when I use the macros (it is several steps) before giving a name for the new worksheet and complete the task. This is where the problem comes and gives an error says that Template not found to complete this macro. It works fine when I leave it as .xlt and saves in the above mentioned folder. It does not work when save as .xltx or .xltm. I have been trying for days. Any suggestions would be greatly appreciated. XX23 "XX23" wrote: I have macros created in excel 2003 (*.xla) as an add-in and wanted to upgrade them to excel 2007. Also, there is an excel template (*.xlt) that works in conjunction with these macros. First, I open the files and save as 2007 file formats and trying to get them work. But, it is not working. What should I do? Any suggestions would be greatly appreciated. |
#6
|
|||
|
|||
converting excel 2003 to 2007 file formats
Yes, this template (.xlt) works in conjunction with macro file (add-in) and
was told to save it under c:\programs files\microsoft office\templates\other documents on excel 2003 and worked fine. On 2007, the problem now is when this file is saved as .xltx and saved in the same directory and gets the message as: The macro could not find the template to give a name to the worksheet. It works ok if I leave the template file as .xlt in the same directory on 2007. The problem is with .xltx file. I can not figure out how to solve this problem. We are doing this because the macros needed to upgrade to 2007 file formats and sooner our machines will upgrade to 2007. Any solutions. "Gord Dibben" wrote: Save the add-in(*.xla) as a 2007 add-in *.xlam if you wish but not really necessary. Don't know what you mean by a "template that works in conjunction with these macros" Gord Dibben MS Excel MVP On Thu, 22 Oct 2009 11:27:01 -0700, XX23 wrote: I have macros created in excel 2003 (*.xla) as an add-in and wanted to upgrade them to excel 2007. Also, there is an excel template (*.xlt) that works in conjunction with these macros. First, I open the files and save as 2007 file formats and trying to get them work. But, it is not working. What should I do? Any suggestions would be greatly appreciated. . |
#7
|
|||
|
|||
converting excel 2003 to 2007 file formats
What is the name of the template? Have you changed that in 2007 version?
Having no idea what your macro(s) do in conjunction with your template leaves little room for trouble-shooting. Do you have a hard-coded reference to template.xlt in your macro(s)? Gord On Thu, 22 Oct 2009 14:06:01 -0700, XX23 wrote: Yes, this template (.xlt) works in conjunction with macro file (add-in) and was told to save it under c:\programs files\microsoft office\templates\other documents on excel 2003 and worked fine. On 2007, the problem now is when this file is saved as .xltx and saved in the same directory and gets the message as: The macro could not find the template to give a name to the worksheet. It works ok if I leave the template file as .xlt in the same directory on 2007. The problem is with .xltx file. I can not figure out how to solve this problem. We are doing this because the macros needed to upgrade to 2007 file formats and sooner our machines will upgrade to 2007. Any solutions. "Gord Dibben" wrote: Save the add-in(*.xla) as a 2007 add-in *.xlam if you wish but not really necessary. Don't know what you mean by a "template that works in conjunction with these macros" Gord Dibben MS Excel MVP On Thu, 22 Oct 2009 11:27:01 -0700, XX23 wrote: I have macros created in excel 2003 (*.xla) as an add-in and wanted to upgrade them to excel 2007. Also, there is an excel template (*.xlt) that works in conjunction with these macros. First, I open the files and save as 2007 file formats and trying to get them work. But, it is not working. What should I do? Any suggestions would be greatly appreciated. . |
#8
|
|||
|
|||
converting excel 2003 to 2007 file formats
Yes, I saved the template file from fsform.xlt to fsform.xltx (2007) and
changed the fsform2006.xla to fsform2007.xlam (add-in file) and this add-in file has a series of buttons that run macros, which I use to create and edit financial statements. I am not a VB programmer and just doing testing those to work. Yes, in the VB code, there is a place it says "Financials could not find the Template" and I checked the template file and it is not showing anywhere in the code. Why it does not let me save the worksheet and gives me error message "FS could not find the template". Also, I checked in the add-ins and that file (.xltx) is there and not working. Also, in VB references, Missing fsform.xlt was checked on. So, I unchecked it and still not working. Any solutions to this would be greatly appreciated. "Gord Dibben" wrote: What is the name of the template? Have you changed that in 2007 version? Having no idea what your macro(s) do in conjunction with your template leaves little room for trouble-shooting. Do you have a hard-coded reference to template.xlt in your macro(s)? Gord On Thu, 22 Oct 2009 14:06:01 -0700, XX23 wrote: Yes, this template (.xlt) works in conjunction with macro file (add-in) and was told to save it under c:\programs files\microsoft office\templates\other documents on excel 2003 and worked fine. On 2007, the problem now is when this file is saved as .xltx and saved in the same directory and gets the message as: The macro could not find the template to give a name to the worksheet. It works ok if I leave the template file as .xlt in the same directory on 2007. The problem is with .xltx file. I can not figure out how to solve this problem. We are doing this because the macros needed to upgrade to 2007 file formats and sooner our machines will upgrade to 2007. Any solutions. "Gord Dibben" wrote: Save the add-in(*.xla) as a 2007 add-in *.xlam if you wish but not really necessary. Don't know what you mean by a "template that works in conjunction with these macros" Gord Dibben MS Excel MVP On Thu, 22 Oct 2009 11:27:01 -0700, XX23 wrote: I have macros created in excel 2003 (*.xla) as an add-in and wanted to upgrade them to excel 2007. Also, there is an excel template (*.xlt) that works in conjunction with these macros. First, I open the files and save as 2007 file formats and trying to get them work. But, it is not working. What should I do? Any suggestions would be greatly appreciated. . . |
#9
|
|||
|
|||
converting excel 2003 to 2007 file formats
Can you open fsform.xltx then in VBE select fsform2007.xlam and through
ToolsReferences checkmark fsform.xltx. Save fsform2007.xlam I have not worked with 2007 enough to be able to trouble-shoot much. I am only guessing at this. Gord On Fri, 23 Oct 2009 05:56:01 -0700, XX23 wrote: Yes, I saved the template file from fsform.xlt to fsform.xltx (2007) and changed the fsform2006.xla to fsform2007.xlam (add-in file) and this add-in file has a series of buttons that run macros, which I use to create and edit financial statements. I am not a VB programmer and just doing testing those to work. Yes, in the VB code, there is a place it says "Financials could not find the Template" and I checked the template file and it is not showing anywhere in the code. Why it does not let me save the worksheet and gives me error message "FS could not find the template". Also, I checked in the add-ins and that file (.xltx) is there and not working. Also, in VB references, Missing fsform.xlt was checked on. So, I unchecked it and still not working. Any solutions to this would be greatly appreciated. "Gord Dibben" wrote: What is the name of the template? Have you changed that in 2007 version? Having no idea what your macro(s) do in conjunction with your template leaves little room for trouble-shooting. Do you have a hard-coded reference to template.xlt in your macro(s)? Gord On Thu, 22 Oct 2009 14:06:01 -0700, XX23 wrote: Yes, this template (.xlt) works in conjunction with macro file (add-in) and was told to save it under c:\programs files\microsoft office\templates\other documents on excel 2003 and worked fine. On 2007, the problem now is when this file is saved as .xltx and saved in the same directory and gets the message as: The macro could not find the template to give a name to the worksheet. It works ok if I leave the template file as .xlt in the same directory on 2007. The problem is with .xltx file. I can not figure out how to solve this problem. We are doing this because the macros needed to upgrade to 2007 file formats and sooner our machines will upgrade to 2007. Any solutions. "Gord Dibben" wrote: Save the add-in(*.xla) as a 2007 add-in *.xlam if you wish but not really necessary. Don't know what you mean by a "template that works in conjunction with these macros" Gord Dibben MS Excel MVP On Thu, 22 Oct 2009 11:27:01 -0700, XX23 wrote: I have macros created in excel 2003 (*.xla) as an add-in and wanted to upgrade them to excel 2007. Also, there is an excel template (*.xlt) that works in conjunction with these macros. First, I open the files and save as 2007 file formats and trying to get them work. But, it is not working. What should I do? Any suggestions would be greatly appreciated. . . |
#10
|
|||
|
|||
converting excel 2003 to 2007 file formats
Gord -
I will try and let you know. xx23 "Gord Dibben" wrote: Can you open fsform.xltx then in VBE select fsform2007.xlam and through ToolsReferences checkmark fsform.xltx. Save fsform2007.xlam I have not worked with 2007 enough to be able to trouble-shoot much. I am only guessing at this. Gord On Fri, 23 Oct 2009 05:56:01 -0700, XX23 wrote: Yes, I saved the template file from fsform.xlt to fsform.xltx (2007) and changed the fsform2006.xla to fsform2007.xlam (add-in file) and this add-in file has a series of buttons that run macros, which I use to create and edit financial statements. I am not a VB programmer and just doing testing those to work. Yes, in the VB code, there is a place it says "Financials could not find the Template" and I checked the template file and it is not showing anywhere in the code. Why it does not let me save the worksheet and gives me error message "FS could not find the template". Also, I checked in the add-ins and that file (.xltx) is there and not working. Also, in VB references, Missing fsform.xlt was checked on. So, I unchecked it and still not working. Any solutions to this would be greatly appreciated. "Gord Dibben" wrote: What is the name of the template? Have you changed that in 2007 version? Having no idea what your macro(s) do in conjunction with your template leaves little room for trouble-shooting. Do you have a hard-coded reference to template.xlt in your macro(s)? Gord On Thu, 22 Oct 2009 14:06:01 -0700, XX23 wrote: Yes, this template (.xlt) works in conjunction with macro file (add-in) and was told to save it under c:\programs files\microsoft office\templates\other documents on excel 2003 and worked fine. On 2007, the problem now is when this file is saved as .xltx and saved in the same directory and gets the message as: The macro could not find the template to give a name to the worksheet. It works ok if I leave the template file as .xlt in the same directory on 2007. The problem is with .xltx file. I can not figure out how to solve this problem. We are doing this because the macros needed to upgrade to 2007 file formats and sooner our machines will upgrade to 2007. Any solutions. "Gord Dibben" wrote: Save the add-in(*.xla) as a 2007 add-in *.xlam if you wish but not really necessary. Don't know what you mean by a "template that works in conjunction with these macros" Gord Dibben MS Excel MVP On Thu, 22 Oct 2009 11:27:01 -0700, XX23 wrote: I have macros created in excel 2003 (*.xla) as an add-in and wanted to upgrade them to excel 2007. Also, there is an excel template (*.xlt) that works in conjunction with these macros. First, I open the files and save as 2007 file formats and trying to get them work. But, it is not working. What should I do? Any suggestions would be greatly appreciated. . . . |
|
Thread Tools | |
Display Modes | |
|
|