Activate the solver witin a macro

[P Sellmeijer]

Hi
How shoud i activate the solver (if possible) from a macro?

Peter

 

[Guest]

Hi,

Try:-

Sub ordinate()
SolverOk SetCell:="$C$1", MaxMinVal:=3, ValueOf:="8", ByChange:="$A$1"
SolverSolve
End Sub

Mike

 

[P Sellmeijer]

Hi Mike,

Thanks for your reply.
Unfortunaly while running your macro i get an error at 'SolverOk" or
"SolverSolve"
with the comment "Sub or Function not5 defined".
I suppose that something should be declaired, but i do'nt know.

Peter

 

[Tushar Mehta]

Look up any Solver related topic (for example SolverSolve) in XL VBA
help. The 2nd paragraph will tell you what you have to do to make it
work.