Show trial solution

L

lui78

I am running the solver from a loop into a macro; so the solver is called
iteratively from the VB script and the solution is not always reached causing
the windows:

"show trial solution: maximum iteration limit was reached; continue anyway?"

or

"show trial solution: maximum time was reached; continue anyway?"

(and the execution is stopped until I don't press STOP or CONTINUE...)
in my case I always have to reply : "STOP"

The question is : is there a command to answer this dialogue box from the VB
script?

If no, is it possible to hide this window in some way without stopping the
execution of the whole program?

If you know the answer please tell me ....Thank You very much !

L.
 
A

abhowan

lui78 said:
I am running the solver from a loop into a macro; so the solver i
called
iteratively from the VB script and the solution is not always reache
causing
the windows:

"show trial solution: maximum iteration limit was reached; continue
anyway?"

or

"show trial solution: maximum time was reached; continue anyway?"

(and the execution is stopped until I don't press STOP or CONTINUE...)
in my case I always have to reply : "STOP"

The question is : is there a command to answer this dialogue box fro
the VB
script?

If no, is it possible to hide this window in some way without stoppin
the
execution of the whole program?

If you know the answer please tell me ....Thank You very much !

L.
Click to expand...




I ran into a similar problem recently. Unfortunately, I could not fin
a way to do this programmatically or via an excel setting. I basicall
needed to run the program overnight without needing intervention. M
solution although very crude, worked like a charm.

If you look at the window that pops up, one of the options is Stop. Th
shortcut key for this is Alt-t. The trick is to keep Alt-t pressed whil
the program is running. I got this done by using some sticky tape an
sticking the alt key down the keyboard. Keeping the 't' key pressed i
a bit more tricky. You will have to use a weight to hold the key down

Hope this works for you


Cheer
 
Top