Re: Solver Error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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
> >> >> >
> >>
> >>
> >>
>
>
>
.

Quantcast