I am using VBA script to run the standard excel solver
automatically every minute or so in an excel spreadsheet
and it runs reasonably well however occasionally (Once
every 12 to 24 hrs) I receive a dialog box indicating "The
maximum time limit was reached; continue anyway?". Is
there VB code I can use to automatically close this
dialogue if it appears box by choosing 'stop'
or 'continue' or will a user have to manually intervene?
For example I use "SolverSolve UserFinish:=True"
and "SolverFinish" in my current code to prevent user
intervention. I have tried extending the maximum time in
the options and that does not appear to make a large
difference.