Installing Solver Error

[George Sanders]

Hey everyone,


I have a spreadsheet that needs to use solver, I have the following code to install the solver add-in when required:

Application.AddIns("Solver Add-in").Installed = True

All is working fine on the computer used to develop the spreadsheet, however when I tried it out on a few other computers I am getting the following error:




Run-time error '1004':
Unable to set the Installed property of the AddIn class


Anyone have any suggestions to why this is happening?

Thanks in advance for any help.