access the solver reference library

C

CAB

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
 
T

Tushar Mehta

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
 
T

Tim Anderson

In order to access the Solver Reference library, go to
Tools -> References and ensure SOLVER is checked. Then it
should work fine.

Tim Anderson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Solver iteration in VBA macro 2
VBA not adding elements to Solver model 0
Solver marco still prompts to keep solution 1
Solver ignores constraints in protected sheets XL 2003 1
Excel Solver in VB 4
Another solver question 1
VBA code to RUN Solver mutiple times (on different target cells) 8
Using Solver Thru VBA 2

Top