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

In article <[email protected]>,
[email protected] 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.
>
>
>

[Chad]

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 <[email protected]>,
> [email protected] 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.
> >
> >
> >
>

[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.
--
Dana DeLouis
Win XP & Office 2003


"Chad" <[email protected]> wrote in message
news:[email protected]...
> 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 <[email protected]>,
>> [email protected] 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.
>> >
>> >
>> >
>>

[sofiaventura]

Hello guys!
First time I post. I don't understand nothing to do with codes or VBA, so I didn't understand what I have to do to fix the problem above.
I recorded a macro to run solver, and I've already activated the solver in references but I keep geting the error: An Expected Internal Error Occurred, Or Available Memory.
Can you help me?

[arlu1201]

sofiaventura,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

[sofiaventura]

Thanks for the advice!