Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
access the solver reference library
Can you access the solver reference library in Excel 2002
sp 2 e.g. Sub RunSolver() ' Set up and run Solver. SolverOk SetCell:=Range("PortStdev"), MaxMinVal:=2, _ ByChange:=Range("Weights") SolverAdd CellRef:=Range("SumWts"), Relation:=2, FormulaText:=1 SolverAdd CellRef:=Range("MeanReturn"), Relation:=3, _ FormulaText:="ReqdReturn" SolverOptions AssumeNonNeg:=True SolverSolve UserFinish:=True End Sub I can't establish a reference to the solver library. TIA |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
access the solver reference library
Have you checked XL VBA help for the SolverOK function? The 2nd
paragraph details how to establish a reference to the Solver library. -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Can you access the solver reference library in Excel 2002 sp 2 e.g. Sub RunSolver() ' Set up and run Solver. SolverOk SetCell:=Range("PortStdev"), MaxMinVal:=2, _ ByChange:=Range("Weights") SolverAdd CellRef:=Range("SumWts"), Relation:=2, FormulaText:=1 SolverAdd CellRef:=Range("MeanReturn"), Relation:=3, _ FormulaText:="ReqdReturn" SolverOptions AssumeNonNeg:=True SolverSolve UserFinish:=True End Sub I can't establish a reference to the solver library. TIA |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
access the solver reference library
In order to access the Solver Reference library, go to
Tools - References and ensure SOLVER is checked. Then it should work fine. Tim Anderson -----Original Message----- Can you access the solver reference library in Excel 2002 sp 2 e.g. Sub RunSolver() ' Set up and run Solver. SolverOk SetCell:=Range("PortStdev"), MaxMinVal:=2, _ ByChange:=Range("Weights") SolverAdd CellRef:=Range("SumWts"), Relation:=2, FormulaText:=1 SolverAdd CellRef:=Range("MeanReturn"), Relation:=3, _ FormulaText:="ReqdReturn" SolverOptions AssumeNonNeg:=True SolverSolve UserFinish:=True End Sub I can't establish a reference to the solver library. TIA . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 compatability, VBA Reference, MicrosoftOffice12. Object Library | Excel Discussion (Misc queries) | |||
Naming word tables or coding reference library with vba | Charts and Charting in Excel | |||
I need to get the reference library from Small Business Financials | Excel Discussion (Misc queries) | |||
How to check Solver and Forms 2.0 Object Library permanently? | Excel Discussion (Misc queries) | |||
Setting up Reference Library using VBA | Excel Programming |