Add-in file path Excel 2000?

[Ago]

I have created a Add-in file in Excel 2007 and that means it's a xlam-file.

And now a user with Excel 2000 wants to use this file.

Can older versions of Excel such as 2000 use this file?
I know they use xla files, but can I just rename it and it will work?
And what folder/path is the correct one for this version of Excel?

The user speaks rather bad english and does not seem to listen.
So my plan is to make a installfile so that "userinput" is minimal :-)

Any help is appreciated

Ago

[Teeroy]

Because of the file structure change in excel 2007 you can't just change the file extension but if you open the original workbook that the xlam was created from you can save it with an xla extension.

[Ago]

I couldn't resave the xlam as a xla, it was grayed in Excel.
But I exported all the userforms and copied the code, and made a new xla file.
Lets see if that works.

Thank you very much.

[Teeroy]

The easy way is to start one level higher than the xlam, with the original workbook. But the steps you took essentially recreated the workbook. I hope it works for you.

[Ago]

I understand what you say, but I don't have the workbook anymore.
It was a long time ago since that got lost, and I guess I didn't think I would need it.

But searching for a solution to my feature problem, having two versions of the same add-in and updating them both.
I found something that hopefully and might work, if I use ThisWorkbook.addin = true and then ThisWorkbook.saveas "filename.xla"
And having that as a modulecode would that solve my problem?