View Single Post
  #24   Report Post  
Posted to microsoft.public.excel.programming
programmernovice[_2_] programmernovice[_2_] is offline
external usenet poster
 
Posts: 61
Default Problem loading Solver

On Tuesday, December 17, 2019 at 8:00:38 AM UTC-6, Peter T wrote:
"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


Thanks Peter. In case it's helpful to you:

SolverSolve True

works. Regards