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.

.