solver: an unexpected internal error occurred, or available memory was exhausted
in [Programming]
|
Prev: Chart problem - works in VBA, but not VB.Net
Next: Using SessionVariable(LOGON_USER) in VBA Excel macro
From: sedelblut on 12 Nov 2006 22:54 SolverOk MaxMinVal:=1, ValueOf:="0", ByChange:="$H$4,$F$15,$F$27" SolverAdd CellRef:="$H$8", Relation:=2, FormulaText:="$I$8" SolverAdd CellRef:="$L$15", Relation:=2, FormulaText:="$I$4" SolverAdd CellRef:="$L$17", Relation:=2, FormulaText:="$I$4" SolverSolve UserFinish:=True SolverFinish KeepFinal:=1 tried solverreset, etc. does not work, What is wrong? Thank You Stephen
From: sedelblut on 12 Nov 2006 22:58 oh, i;m using excel 2003 in windows xp
From: Graham Whitehead on 13 Nov 2006 04:39
I seem to remember having the same problem a while ago. try adding the following two lines at the beginning of your code: Application.Run "Solver.xla!Auto_Open" SolverReset <sedelblut(a)gmail.com> wrote in message news:1163390080.743066.81290(a)h54g2000cwb.googlegroups.com... > SolverOk MaxMinVal:=1, ValueOf:="0", ByChange:="$H$4,$F$15,$F$27" > SolverAdd CellRef:="$H$8", Relation:=2, FormulaText:="$I$8" > SolverAdd CellRef:="$L$15", Relation:=2, FormulaText:="$I$4" > SolverAdd CellRef:="$L$17", Relation:=2, FormulaText:="$I$4" > SolverSolve UserFinish:=True > SolverFinish KeepFinal:=1 > > tried solverreset, etc. does not work, What is wrong? > > Thank You > Stephen > |