View Single Post
  #23   Report Post  
Posted to microsoft.public.excel.programming
Peter T[_8_] Peter T[_8_] is offline
external usenet poster
 
Posts: 88
Default Problem loading Solver

"programmernovice" wrote in message

The final pop-up from Solver (Solver Results) requires user to click on the
OK button to close it. Is there some way via VBA to do this and completely
automate the process.

===============================

It's a while since I've used it, I vaguely recall there is a way though it
seems to have a mind of it's own whether the final dialog appears, or maybe
it's the overall scenario. See if you can find something in the following:

https://www.solver.com/excel-solver-vba-functions
https://peltiertech.com/Excel/SolverVBA.html

Peter T