I have a workbook which is saved as a 2003 type but is used by version 2007.
I have the Add-in "Analysis ToolPak - VBA" installed on the 2003 but when I run my code in 2007 it cannot find the project library atpvbaen.xla In the VBA reference it is MISSING.
If I untick and tick the 2007 AddIn I then get MISSING atpvbaen.xlam when running the code back in the 2003 version.
Is it possible to run some code on the workbook open event similar to that below to install the appropriate AddIn for the excel version running.
If Application.Version < 12 Then
AddIns("atpvbaen.xla").Installed = True
AddIns("atpvbaen.xlam").Installed = False
AddIns("atpvbaen.xla").Installed = False
AddIns("atpvbaen.xlam").Installed = True