How do I automatically accept a solver solution in a macro?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The macro seems to always stop at the solver results dialogue box even though
I want it to automatically keep the solver solution.
 
The macro seems to always stop at the solver results dialogue box even though
I want it to automatically keep the solver solution.
Click to expand...
Check out XL VBA help for the SolverSolve function, particularly, its
UserFinish argument.

You may also want to check out the SolverFinish function.

--
Regards,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Solver programming questions 8
"DoEvents"-type behavior in Solver? 1
Automatically load solver reference library 4
Identical Solver for Many Worksheets 0
Premium Solver Macro Problem 3
Solver add-in 2
stop VBA in solver when maximum iterations reached 3
Another solver question 1

Back
Top