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

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

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

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

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

Hi Dana

This has me confused now! Your macro seems to work fine but having run it
when I try and work solver on another machine it still says it can't find it.

This is even though when stepping through your macro, when hovering over "If
Not AddIns("Solver Add-In").Installed" it clearly says that evaluates to True.

I think I may have to do the solving manually instead as it's not a hugely
complex solver scenario!

Thanks for your help anyway...

Phil

"Dana DeLouis" wrote:

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

Hi. If you put this in the beginning, what do you get?

If Dir(Application.LibraryPath & "\SOLVER\SOLVER.XLA") = vbNullString
Then
MsgBox "SOLVER.XLA not in Library Path"
Else
MsgBox "SOLVER.XLA appears to be in the correct location"
End If

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


"Defoes Right Boot" wrote in
message ...
Hi Dana

This has me confused now! Your macro seems to work fine but having run it
when I try and work solver on another machine it still says it can't find
it.

This is even though when stepping through your macro, when hovering over
"If
Not AddIns("Solver Add-In").Installed" it clearly says that evaluates to
True.

I think I may have to do the solving manually instead as it's not a hugely
complex solver scenario!

Thanks for your help anyway...

Phil

"Dana DeLouis" wrote:

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

I'm just curious. If you unload Solver, and then re-load, will that work?

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

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

If Dir(SolverPath) = vbNullString Then
MsgBox "SOLVER.XLA not in Library Path"
Exit Sub
End If

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

AddIns("Solver Add-In").Installed = False
'// We remembered ActiveWorkbook before Solver gets Focus...
AddIns("Solver Add-In").Installed = True

wb.VBProject.References.AddFromFile SolverPath
wb.Activate
End Sub

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


<snip

"Defoes Right Boot" wrote in
message ...
Hi Dana

This has me confused now! Your macro seems to work fine but having run it
when I try and work solver on another machine it still says it can't find
it.

This is even though when stepping through your macro, when hovering over
"If
Not AddIns("Solver Add-In").Installed" it clearly says that evaluates to
True.

I think I may have to do the solving manually instead as it's not a
hugely
complex solver scenario!

Thanks for your help anyway...

Phil

<snip