On Tuesday, December 17, 2019 at 10:14:56 AM UTC-6, Peter T wrote:
"Peter T" wrote in message
...
"programmernovice" wrote in message
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
Indeed that's what the documentation says, but don't be surprised if the
dialog appears again!
Peter T
.. and looking back at your post with your code you already had exactly
that...?
PT
Well, for now it works. My code had just
SolverSolve
Addition of "True" appears to have helped. Hopefully it will remain so. Thanks, regards