Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Solver from an Excel 2003 Macro
When I use Solver manually in my spreadsheet it works as
expected. When I call it from a macro, I get an VBA error saying that a subroutine or function is not referenced. When I go to Tools - References I can't find Solver.XLA in the tick box list of Addins. Does anyone know how to force Excel to update this list, to include the Solver Addin? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Solver from an Excel 2003 Macro
You have to go to the VBE and go to tools=references, find solver in the
list and click the box to select it. http://support.microsoft.com/support...ver/solver.asp Creating Visual Basic Macros that Use Microsoft Excel Solver or to do it in VBA (post by Dana DeLouis) 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 -- Regards, Tom Ogilvy "expatgr" wrote in message ... When I use Solver manually in my spreadsheet it works as expected. When I call it from a macro, I get an VBA error saying that a subroutine or function is not referenced. When I go to Tools - References I can't find Solver.XLA in the tick box list of Addins. Does anyone know how to force Excel to update this list, to include the Solver Addin? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you use solver in excel 2003 | Excel Discussion (Misc queries) | |||
Calling solver | Excel Programming | |||
Calling up the Solver function in a VBA macro | Excel Programming | |||
Calling Solver from VBA | Excel Programming | |||
Calling the Solver via a subroutine | Excel Programming |