View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevin Beckham Kevin Beckham is offline
external usenet poster
 
Posts: 78
Default Solver and Excel 2003

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