View Single Post
  #26   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


"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