Hi. Hope this helps. :)

Sub SolverInstall()
'// Dana DeLouis
Dim SolverPath As String
Dim wb As Workbook

On Error Resume Next
' Solver will have Focus if opened:
' So, remember ActiveWorkbook (adjust as needed)...
Set wb = ActiveWorkbook

SolverPath = Application.LibraryPath & "\SOLVER\SOLVER.XLA"

If Not AddIns("Solver Add-In").Installed _
Then AddIns("Solver Add-In").Installed = True

wb.VBProject.References.AddFromFile SolverPath

wb.Activate
End Sub

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"Bill Martin" wrote in message
...
No way that I'm aware of, but there are a lot of more clever people than I
here who may provide you with an answer. Good luck.

Bill
------------------
On Wed, 22 Feb 2006 08:32:34 -0800, Defoes Right Boot wrote:

Hi Bill

I have not checked all the machines but on the one I did check I found
Solver on the hard disk, but in a different path to the one it is in on
my
machine. Once I had manually installed it on this machine the macro
worked
fine, but then I exited Excel and tried again and it came up with the
same
error as previously.

Is there some way to automatically find Solver on the HD and install it
at
the start of the macro or alternatively on opening the worksheet?

Phil

"Bill Martin" wrote:

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