Solver and Excel 2003

[Kevin Beckham]

I am getting the following message with Excel 2003
Solver: An unexpected internal error occurred, or
available memory was exhausted
and I'm running under Windows 2000

I didn't get it with Excel 2000.
The VBA code references Solver,
and the error occurs for the SolverOK call, viz.

SOLVER.VBA_Functions.SolverOk SetCell:="$C$38",
MaxMinVal:=2, ValueOf:="0", _
ByChange:="$F$39,$F$40,$F$41"

Prior SolverAdd calls don't raise errors.
If I start a Solver seesion within the workbook from the
Tools menu, then run the VBA code, the problem goes away,
even if I just cancel the dialog box.

Has anyone a work-around ?
TIA
Kevin Beckham

 

[Kevin Beckham]

The following code needs to be inserted before any call
to Solver (confirmed) or added to Workbook_Open
(unconfirmed)

If Not SOLVER.AutoOpened Then
SOLVER.Auto_open
End If

Kevin Beckham