Problem: Solving problems becomes slower the more often I call the SolverOK function in a VBA Excel 2002 code.

I am using the solver add in my program and I was wondering if that will use up a lot of __memory__ and I want to make sure that I release the memory properly. The solver is called several 1000 times in this routine and it could possibly produce a big mess if it does release the memory correctly.

Any help is appreciated.

Code example

'Open solver library

Application.Run "Solver.xla!Auto_Open"

'Clear solver contraints

SOLVERReset

For i=1 to 100

'Set solver contraints

SolverAdd CellRef:="$H$114", Relation:=1, FormulaText:="$H$103"

SolverAdd CellRef:="$H$119", Relation:=3, FormulaText:="$H$103"

'Call solver and calculate result

SolverOk SetCell:="$H$101", MaxMinVal:=2, ValueOf:="0", ByChange:="$H$103"

SolverSolve UserFinish:=True

SolverFinish KeepFinal:=1

'reset solver after the job is done

SOLVERReset

NEXT

' close solver library

Application.Run "Solver.xla!Auto_Close"