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