Solver Add-in problems with VBA

W

Wayne Stewart

I am posting this message again since I was not getting
any more feedback on my original Jan. 26 posted comments.
Hope someone can provide some assistance.

********************************

Thank-you Dana and Ken for your feedback to my Excel 2000
macro problem with the Solver Add-in.

I reviewed the website that Dana provided below and it
looks like the problem is with Excel 2000 SP-3. I would
like to download the patch as discussed on this website
but I can't figure out a "no charge" way of requesting the
patch. Every phone number listed seems to cost $$.

Is there a way I can download or have someone email me
this patch without incurring any cost? I can't really
afford to wait until the next service pack comes out (SP-
4).

Thanks again.
-----Original Message-----
XL2000: The Solver Add-in May Not Work When You Start Solver by Using a
Macro

http://support.microsoft.com/default.aspx?scid=kb;en- us;821430&Product=xlw

CAUSE
This problem may occur after you install Microsoft Office 2000 Service Pack
3 (SP-3).

HTH.

As a side note, although it works, it may be slightly better to not include
() around the "True" statement. They are "usually" used when testing the
results of Solver, as in the following idea...

Sub ExampleSolve()
Dim Result
SolverReset '<- Clean up
SolverOk [A3], 3, 10, [A1]
Result = SolverSolve(True)
'Or
SolverSolve True
End Sub

--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =

<snip>
Click to expand...
 
Top