Solver: An unexpected internal error occurred, or available memory

[Chad]

I get the following error when I run a VBA macro on a machine other than the
one used to write the code:

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

The interesting thing is that when I open and run Solver from the menu, it
initializes and works properly thereafter.

I found an article describing a problem with Office 2000 that is quite
similar (if not the same thing) but nothing for Office XP 2003.

I suspect the problem has something to do with the initialization of Solver
or perhaps a path.

 

[Tushar Mehta]

Add the statement SOLVER.Auto_open before you attempt to do anything
else with Solver. Hopefully, that will solve your problem.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Chad]

That does it! Thanks a lot for the help.

Chad

Add the statement SOLVER.Auto_open before you attempt to do anything
else with Solver. Hopefully, that will solve your problem.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Dana DeLouis]

Chad. Could you do me a favor and test these two codes? I see that the
problem is when you are running Solver on a machine other than the one used
to write the code. I would appreciate the feedback. Thanks.

You would have to restart Excel. For this code, could you tell me if you
get the message "Not Reset" Thanks.

Sub Demo()
If Not SOLVER.AutoOpened Then
MsgBox "Not Reset"
SOLVER.Auto_open
End If
End Sub

Out of curiosity, could you tell me if the following works just as well.
Thanks.

Sub Demo2()
'// See if this works out of curiosity...
SOLVER.SolverName
'Continue with your code...
End Sub

Thanks for the feedback.