Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver: An unexpected internal error occurred, or available memory
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver: An unexpected internal error occurred, or available memory
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 In article , says... 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver: An unexpected internal error occurred, or available me
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. -- Dana DeLouis Win XP & Office 2003 "Chad" wrote in message ... That does it! Thanks a lot for the help. Chad "Tushar Mehta" wrote: 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 In article , says... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver Error - an unexpected internal error has occurred | Excel Discussion (Misc queries) | |||
Solver Error - an unexpected internal error has occurred | Excel Discussion (Misc queries) | |||
Solver Error - an unexpected internal error has occurred | Excel Discussion (Misc queries) | |||
Solver Error - an unexpected internal error has occurred | Excel Discussion (Misc queries) | |||
WinXP: Solver: An unexpected internal error occurred ... | Excel Programming |