How do I respond to a Solver Results Dialog Box from a macro?

[Guest]

I am using Solver in a macro.
When finished, Solver displays Solver Results dialog box and halts the macro.
Instead of clicking the OK-button with the mouse, to resume the macro, I
want to do the OK acknowledge from within the macro, thus allowing the macro
to run uninterrupted from start to finish.
Is this possible and if so how?

 

[Tushar Mehta]

I am using Solver in a macro.
When finished, Solver displays Solver Results dialog box and halts the macro.
Instead of clicking the OK-button with the mouse, to resume the macro, I
want to do the OK acknowledge from within the macro, thus allowing the macro
to run uninterrupted from start to finish.
Is this possible and if so how?

Check XL VBA help for the SolverSolve function, particularly the
UserFinish argument.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions