Thread: How do I automatically accept a solver solution in a macro?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tushar Mehta Tushar Mehta is offline
external usenet poster
  
Posts: 1,071
Default How do I automatically accept a solver solution in a macro?
In article ,
says...
The macro seems to always stop at the solver results dialogue box even though
I want it to automatically keep the solver solution.

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
Reply With QuoteReply With Quote