I suspect those other machines have not installed Solver from the CD so
it's nowhere to be found on their hard drives and thus cannot be called up
from software -- it takes wetware to shove the CD in the drive, etc.

Bill

--------------------------

On Wed, 22 Feb 2006 01:34:50 -0800, Defoes Right Boot wrote:

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