Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 sp3 problem with vba and Solver AddIn
I'm having the problem outlined in Microsoft KB 821430 - "XL2000: The
Solver Add-in May Not Work When You Start Solver by Using a Macro". More info at: http://support.microsoft.com/default...b;en-us;821430 Briefly, some users of Excel 2000 with sp3 cannot use vba to run the Solver Add-In. In my case (and I assume for others), VBA runs the solver, but does not use any of the vba specified parameters. Micro$oft has a fix...which is not available on any website...and you have to contact tech support and pay $$...or wait til they release sp4. I could work around it but I am developing an application for a client, and the users are potentially running 2000 sp3. The solver part needs to be automated, thus the reason for using vba. Has anyone found another solution? Any work around? I'm not feeling warm and fuzzy about writing my own solver. Thanks, Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver and Addin | Excel Discussion (Misc queries) | |||
Solver Addin | Excel Discussion (Misc queries) | |||
excel solver addin | Excel Programming | |||
Addin for Excel 2000/97 (In Visual Basic) | Excel Programming | |||
Excel solver addin. | Excel Programming |