Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver and Excel 2003
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 -----Original Message----- 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 + Solver | Excel Worksheet Functions | |||
how do you use solver in excel 2003 | Excel Discussion (Misc queries) | |||
How can I install Excel Solver without the Office 2003 disk? | Excel Worksheet Functions | |||
Excel 2003 + Solver + C# | Excel Programming | |||
Excel 2003 + Solver + C# | Excel Programming |