| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver marco still prompts to keep solution
Greetings. I was able to record a macro for solver, and it works like a
charm. However, even though I did not stop recording until after I chose "keep solver solution", and then hit ok, the dialog box asking me if I want to keep the solution still pops up. Any ideas on how to get it to automaticall keep the solution if one is found? Below is the macro. Thank you Greg SolverReset SolverOk SetCell:="$N$7", MaxMinVal:=2, ValueOf:="0", ByChange:="$B$8:$M$8" SolverAdd CellRef:="$N$3:$N$7", Relation:=1, FormulaText:="$P$3:$P$7" SolverAdd CellRef:="$N$8", Relation:=2, FormulaText:="$P$8" SolverOk SetCell:="$N$7", MaxMinVal:=2, ValueOf:="0", ByChange:="$B$8:$M$8" SolverOptions MaxTime:=100, Iterations:=100, Precision:=0.000001, AssumeLinear _ :=True, StepThru:=False, Estimates:=1, Derivatives:=1, SearchOption:=1, _ IntTolerance:=5, Scaling:=False, Convergence:=0.0001, AssumeNonNeg:=True SolverOk SetCell:="$N$7", MaxMinVal:=2, ValueOf:="0", ByChange:="$B$8:$M$8" SolverSolve |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Solver marco still prompts to keep solution
Ok, found my answer here right after I posted.
SolverSolve userfinish:=True "Greg Snidow" wrote: Greetings. I was able to record a macro for solver, and it works like a charm. However, even though I did not stop recording until after I chose "keep solver solution", and then hit ok, the dialog box asking me if I want to keep the solution still pops up. Any ideas on how to get it to automaticall keep the solution if one is found? Below is the macro. Thank you Greg SolverReset SolverOk SetCell:="$N$7", MaxMinVal:=2, ValueOf:="0", ByChange:="$B$8:$M$8" SolverAdd CellRef:="$N$3:$N$7", Relation:=1, FormulaText:="$P$3:$P$7" SolverAdd CellRef:="$N$8", Relation:=2, FormulaText:="$P$8" SolverOk SetCell:="$N$7", MaxMinVal:=2, ValueOf:="0", ByChange:="$B$8:$M$8" SolverOptions MaxTime:=100, Iterations:=100, Precision:=0.000001, AssumeLinear _ :=True, StepThru:=False, Estimates:=1, Derivatives:=1, SearchOption:=1, _ IntTolerance:=5, Scaling:=False, Convergence:=0.0001, AssumeNonNeg:=True SolverOk SetCell:="$N$7", MaxMinVal:=2, ValueOf:="0", ByChange:="$B$8:$M$8" SolverSolve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automate a Solver solution | Excel Worksheet Functions | |||
| Validating solver solution | Excel Discussion (Misc queries) | |||
| How do I save a solver solution in VBA | Excel Discussion (Misc queries) | |||
| Using Solver - integer solution | Excel Discussion (Misc queries) | |||
| Solver won't keep the solution. | Excel Programming | |||
Hybrid Mode
