Hi all,
I'm getting the following error when i call solver from VBA.

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

I use excel 2000 SP3 version. Is there any way to get rid of this problem?.
Pls help me out.
Thanks in advance,
Madhavan.R

Can anyone help me out pls?
Regards,
Madhavan.R

"Madhavan" wrote:

Hi all,
I'm getting the following error when i call solver from VBA.

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

I use excel 2000 SP3 version. Is there any way to get rid of this problem?.
Pls help me out.
Thanks in advance,
Madhavan.R

Try this:

http://support.microsoft.com/default...30&Product=xlw

its brand new! 06/08/05

"Madhavan" escreveu:

Hi all,
I'm getting the following error when i call solver from VBA.

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

I use excel 2000 SP3 version. Is there any way to get rid of this problem?.
Pls help me out.
Thanks in advance,
Madhavan.R

Thanks DucA for the updated link.

But after contacting microsoft they say that the fix is available only on a
chargeable basis. I could read the following sentence from the microsoft
support page http://support.microsoft.com/gp/prof...boundary/zh-sg
as "If a problem is determined by Microsoft to be the result of a defect in
a Microsoft product, the customer will not be charged for that incident".

Could anyone or any MVP's clarify me...

Thanks,
Madhavan.R


"DucA" wrote:

Try this:

http://support.microsoft.com/default...30&Product=xlw

its brand new! 06/08/05

"Madhavan" escreveu:

Hi all,
I'm getting the following error when i call solver from VBA.

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

I use excel 2000 SP3 version. Is there any way to get rid of this problem?.
Pls help me out.
Thanks in advance,
Madhavan.R

Hi. This will not solve your problem, but could you do me a favor and run
this at the start of your macro. I'd be curious what your MsgBox says.
Thanks.

Sub Your_Code()
MsgBox SOLVER.AutoOpened 'Display Flag
SOLVER.Auto_open ' No harm, re-build it anyway...

'// Your code....
End Sub

Are you using the English version of Excel?
--
Dana DeLouis
Win XP & Office 2003


"Madhavan" wrote in message
...
Thanks DucA for the updated link.

But after contacting microsoft they say that the fix is available only on
a
chargeable basis. I could read the following sentence from the microsoft
support page http://support.microsoft.com/gp/prof...boundary/zh-sg
as "If a problem is determined by Microsoft to be the result of a defect
in
a Microsoft product, the customer will not be charged for that incident".

Could anyone or any MVP's clarify me...

Thanks,
Madhavan.R


"DucA" wrote:

Try this:

http://support.microsoft.com/default...30&Product=xlw

its brand new! 06/08/05

"Madhavan" escreveu:

Hi all,
I'm getting the following error when i call solver from VBA.

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

I use excel 2000 SP3 version. Is there any way to get rid of this
problem?.
Pls help me out.
Thanks in advance,
Madhavan.R

Hi Dana DeLouis,
Thanks for the initiative.
The Message box gives me the message "False".
I use english version of Excel.
Curious for your reply...
Madhavan.R


"Dana DeLouis" wrote:

Hi. This will not solve your problem, but could you do me a favor and run
this at the start of your macro. I'd be curious what your MsgBox says.
Thanks.

Sub Your_Code()
MsgBox SOLVER.AutoOpened 'Display Flag
SOLVER.Auto_open ' No harm, re-build it anyway...

'// Your code....
End Sub

Are you using the English version of Excel?
--
Dana DeLouis
Win XP & Office 2003


"Madhavan" wrote in message
...
Thanks DucA for the updated link.

But after contacting microsoft they say that the fix is available only on
a
chargeable basis. I could read the following sentence from the microsoft
support page http://support.microsoft.com/gp/prof...boundary/zh-sg
as "If a problem is determined by Microsoft to be the result of a defect
in
a Microsoft product, the customer will not be charged for that incident".

Could anyone or any MVP's clarify me...

Thanks,
Madhavan.R


"DucA" wrote:

Try this:

http://support.microsoft.com/default...30&Product=xlw

its brand new! 06/08/05

"Madhavan" escreveu:

Hi all,
I'm getting the following error when i call solver from VBA.

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

I use excel 2000 SP3 version. Is there any way to get rid of this
problem?.
Pls help me out.
Thanks in advance,
Madhavan.R

Hi. That is interesting. Did you run your code with the following line at
top?
The line just deletes a small sheet within Solver, and re-builds it. I've
never really understood why it needs to be re-built each time Solver is
loaded normally...perhaps it updates some internal DLL references or
something. I'd be curious on your reply, as this sometimes happens with
later versions of Excel as well, However, I've not experienced this issue
with Office 2003.

Sub Your_Code()
SOLVER.Auto_open ' No harm, re-build it anyway...

'// Your code here...
'// etc...
End Sub

Perhaps at a later time, you can test it with the following:

Sub YourCode()
If Not SOLVER.AutoOpened Then SOLVER.Auto_open
'// Your Solver routine below...
'// etc...
End Sub

--
Dana DeLouis
Win XP & Office 2003


"Madhavan" wrote in message
...
Hi Dana DeLouis,
Thanks for the initiative.
The Message box gives me the message "False".
I use english version of Excel.
Curious for your reply...
Madhavan.R


"Dana DeLouis" wrote:

Hi. This will not solve your problem, but could you do me a favor and
run
this at the start of your macro. I'd be curious what your MsgBox says.
Thanks.

Sub Your_Code()
MsgBox SOLVER.AutoOpened 'Display Flag
SOLVER.Auto_open ' No harm, re-build it anyway...

'// Your code....
End Sub

Are you using the English version of Excel?
--
Dana DeLouis
Win XP & Office 2003


"Madhavan" wrote in message
...
Thanks DucA for the updated link.

But after contacting microsoft they say that the fix is available only
on
a
chargeable basis. I could read the following sentence from the
microsoft
support page http://support.microsoft.com/gp/prof...boundary/zh-sg
as "If a problem is determined by Microsoft to be the result of a
defect
in
a Microsoft product, the customer will not be charged for that
incident".

Could anyone or any MVP's clarify me...

Thanks,
Madhavan.R


"DucA" wrote:

Try this:

http://support.microsoft.com/default...30&Product=xlw

its brand new! 06/08/05

"Madhavan" escreveu:

Hi all,
I'm getting the following error when i call solver from VBA.

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

I use excel 2000 SP3 version. Is there any way to get rid of this
problem?.
Pls help me out.
Thanks in advance,
Madhavan.R

Hello. I have used the code Dana provided below and it is amazing. It
solved my problem right away. Where can I learn about what Dana knew,
when Dana was writing the code? Is there a reference for it somewhere
on the internet, or perhaps a book about it?

Dana DeLouis Wrote:


Sub Your_Code()
MsgBox SOLVER.AutoOpened 'Display Flag
SOLVER.Auto_open ' No harm, re-build it anyway...

'// Your code....
End Sub

Are you using the English version of Excel?
--
Dana DeLouis
Win XP & Office 2003


--
ahmtsn
------------------------------------------------------------------------
ahmtsn's Profile: http://www.excelforum.com/member.php...o&userid=33361
View this thread: http://www.excelforum.com/showthread...hreadid=377346