I have a macro which makes use of the solver add-in.

I want multiple users on multiple machines (which may have Excel installed
in various paths or drives!) to be able to use this.

I have used the line

AddIns("Solver Add-In").Installed = True

to install the add-in at the start of the macro, and it works fine on my
machine however when I try to use it on any other machine it says :

Compile Error - Cannot find project or library.

How can I work the macro so that it correctly installs Solver on any machine?

Thanks

Phil