Solver function
 

I am trying to run the solver through excel VBA. It is going fine, but at
the end it is popping up a message box asking user to intervene ( to accept
the original solution or to keep the solver solution). I need to click ok
manually to accept this. Is there a method by which I can automate this
manual acceptance ?

Thanks
Mahendhra

Solver function
 

Make the last line of the macro:

SolverSolve True


Mahendhra wrote:
I am trying to run the solver through excel VBA. It is going fine, but at
the end it is popping up a message box asking user to intervene ( to accept
the original solution or to keep the solver solution). I need to click ok
manually to accept this. Is there a method by which I can automate this
manual acceptance ?

Thanks
Mahendhra


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html