View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CAB[_2_] CAB[_2_] is offline
external usenet poster
 
Posts: 1
Default 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