solver macro

[maury314]

Anybody help!!!! I run solver manually from the excel menu and it works
Then I recorded it as a macro in VBA and try to run the macro. It say
error: Solver:An unexpected internal error occurred or availabl
memory was exhausted. Please help

 

[BU_Paul]

Check out Knowledge Base Article 821430

XL2000: The Solver Add-in May Not Work When You Start
Solver by Using a Macro
Applies To
SYMPTOMS
When you use Excel 2000 and you use the Solver add-in,
you may experience the following symptoms:
When you run a Microsoft Visual Basic for Applications
(VBA) macro that starts the Solver add-in and that sets
the problem parameters, no calculations occur or problem
solving occurs.
-or-

When you try to solve a problem by setting the problem
parameters in the Solver add-in, you receive the
following error message:

Solver: An unexpected internal error occurred, or
available memory was exhausted.

Note To set the problem parameters in the Solver add-in,
on the Tools menu, click Solver.
CAUSE
This problem may occur after you install Microsoft Office
2000 Service Pack 3 (SP-3).

Note Microsoft has confirmed that this problem only
occurs when you use the English version of Excel 2000.

 

[stratuser]

I have had this problem too. It is a bug that occurs in a
particular release of Excel 2000. You can get a patch
that will fix the problem from the Microsoft website.

 

[Guest]

I have the same proble too

Are you know where is the fix (download)??