Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Solver error with Excel 2000?
Rob. I can't simulate that problem with Excel XP. If you find yourself
having to do it "manually," see if the following idea will correct it. I believe Solver does internally keep track of a flag called "AutoOpened" ' Your Solver Routine... If SOLVER.AutoOpened = False Then SOLVER.Auto_open End If ' Continue... -- Dana DeLouis Using Windows XP & Office XP = = = = = = = = = = = = = = = = = "Rob Bovey" wrote in message ... Hi Dave, I've fixed a similar problem with Solver in the past by manually running its Auto_Open procedure in my VBA code before I do anything else with it. Not sure if this is the same bug or not, but you might give that a try. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Dave Collins" wrote in message ... Does anyone know what the fix is for knowledge base article 821430? It is the the Solver fix for using Office 2000 SP3 and the Solver addin. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver Error - an unexpected internal error has occurred | Excel Discussion (Misc queries) | |||
Excel 2007 Solver Error | Excel Worksheet Functions | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Using the solver in excel 2000 | Excel Discussion (Misc queries) | |||
Where can I download the "solver" add-in for Excel 2000? | Excel Discussion (Misc queries) |