Excel Solver

Hi,

Please suggest some good resources on Excel Solver function (references,
web-links). (I did go to Google but would be happy to have some hallmark
stuff from NG's)

I am experimenting with it and sometimes it gives me non-convergence message
even after it has found a solution and yes many different quirks.

Eventually I want to move towards accessing solver through VBA.

Thanks a lot,
Hari
India

http://support.microsoft.com/support...ver/solver.asp
Creating Visual Basic Macros that Use Microsoft Excel Solver

Solver is a product of frontsys

http://www.frontsys.com/xlhelp.htm
Help for Microsoft Excel Solver Users

http://www.frontsys.com/mlvbaref.htm
VBA Reference


--
Regards,
Tom Ogilvy


"Hari Prasadh" <excel_hariNOSPAM@hotSPAREMEmail.com> wrote in message
news:%23yG3KPGNFHA.2252@TK2MSFTNGP15.phx.gbl...
> Hi,
>
> Please suggest some good resources on Excel Solver function (references,
> web-links). (I did go to Google but would be happy to have some hallmark
> stuff from NG's)
>
> I am experimenting with it and sometimes it gives me non-convergence
message
> even after it has found a solution and yes many different quirks.
>
> Eventually I want to move towards accessing solver through VBA.
>
> Thanks a lot,
> Hari
> India
>
>

Hari Prasadh wrote:
> Hi,
>
> Please suggest some good resources on Excel Solver function (references,
> web-links). (I did go to Google but would be happy to have some hallmark
> stuff from NG's)
>
> I am experimenting with it and sometimes it gives me non-convergence message
> even after it has found a solution and yes many different quirks.
>
> Eventually I want to move towards accessing solver through VBA.
>
> Thanks a lot,
> Hari
> India
>
>

Check out MS KB article 146606 "How to Find Resources on Microsoft Excel
Solver" at http://support.microsoft.com/default...b;en-us;146606)

rv2

Hi Tom and Rv2,

Thnx a lot for your links.

Regards,
Hari
India

"rv2" <Xrhovsquared-newsgroup@Xyahoo.com> wrote in message
news:ufHSt9GNFHA.1476@TK2MSFTNGP09.phx.gbl...
> Hari Prasadh wrote:
>> Hi,
>>
>> Please suggest some good resources on Excel Solver function (references,
>> web-links). (I did go to Google but would be happy to have some hallmark
>> stuff from NG's)
>>
>> I am experimenting with it and sometimes it gives me non-convergence
>> message even after it has found a solution and yes many different quirks.
>>
>> Eventually I want to move towards accessing solver through VBA.
>>
>> Thanks a lot,
>> Hari
>> India
>
> Check out MS KB article 146606 "How to Find Resources on Microsoft Excel
> Solver" at http://support.microsoft.com/default...b;en-us;146606)
>
> rv2