I have some Excel 2002 workbooks used with Excel 2002 Addins that I created and now want to convert some users to Excel 2007. I do not want the users to have access to the VBA Modules, however, I need to change the VBA reference in the users 2002 workbooks to a new Addin with an .xlam extension. Is there a way to make this change with a VBA procedures?

Hi

You can write a small macro to open the xla file and save as xlam in Excel 2007

But it would be better if you could do that from your end as there might be some functions that are not compatible with Excel 2007 and you can fix it

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)