ExcelBanter - Solver VBA control

if you want to set the reference with code, here is some code posted by Dana
DeLouise

http://groups.google.com/groups?thre...gp13 .phx.gbl

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

On Error Resume Next
' Set a Reference to the workbook that will hold Solver
Set wb = ActiveWorkbook

With wb.VBProject.References
.Remove .Item("SOLVER")
End With

With AddIns("Solver Add-In")
.Installed = False
.Installed = True
wb.VBProject.References.AddFromFile .FullName
End With
End Sub

This line adds the reference:
wb.VBProject.References.AddFromFile .FullName

The other parts make sure it is loaded as an addin.
-----------------------------------------------------

----------------- an article you might find useful:

http://support.microsoft.com/support...ver/solver.asp
Creating Visual Basic Macros that Use Microsoft Excel Solver

--
Regards,
Tom Ogilvy

"ChrisK" wrote in message
...

Hi,

I'm controlling Solver via VBA. But to do this you must add in SOLVER
via the Tools References within VBA. If you don't do this first the
macro crashes. However, as I'm going to give this worksheet to other
people is there a way to either automatically add SOLVER in within VBA
or to check it it's loaded?

Any help would be appreciated.

Thanks

Chris

--
ChrisK
------------------------------------------------------------------------
ChrisK's Profile:
http://www.excelforum.com/member.php...o&userid=16375
View this thread: http://www.excelforum.com/showthread...hreadid=277517