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!