Re: Solver Error

I don't have any other ideas at the moment. I would think that Microsoft
would send you the patch for free if you call and reference the kb article.
I've never understood why they won't post the patch anyway. Perhaps call
back and hope you talk with someone else.

--
Dana DeLouis
Win XP & Office 2003


"Madhavan" <Madhavan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:87BE5D82-265F-4882-B8C6-78FDE523BCE4@xxxxxxxxxxxxxxxx
> Hi
> Very first time when i ran, the Msgbox gave me False...From then on it
> gives
> me True everytime...I suppose it should give TRUE as per what u say...
> But this does not solve my problem...
> Yeah...ofcourse i included the SOLVER.Auto_Open at the beginning of my
> code...
> What other possibilities u feel are there to solve this problem...?
> Thanks,
> Madhavan.R
>
>
> "Dana DeLouis" wrote:
>
>> Hi. That is interesting. Did you run your code with the following line
>> at
>> top?
>> The line just deletes a small *** 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" <Madhavan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:9001746E-82C0-4FBD-853D-E1C061D21037@xxxxxxxxxxxxxxxx
>> > 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" <Madhavan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:5C9DA5DE-EDB9-4A49-AA9A-515B399F88F8@xxxxxxxxxxxxxxxx
>> >> > 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/professionalboundary/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.aspx?scid=kb%3Ben-us%3B821430&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
>> >> >> >
>> >>
>> >>
>> >>
>>
>>
>>


.