Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Show trial solution
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. |
#2
|
|||
|
|||
Quote:
I ran into a similar problem recently. Unfortunately, I could not find a way to do this programmatically or via an excel setting. I basically needed to run the program overnight without needing intervention. My solution although very crude, worked like a charm. If you look at the window that pops up, one of the options is Stop. The shortcut key for this is Alt-t. The trick is to keep Alt-t pressed while the program is running. I got this done by using some sticky tape and sticking the alt key down the keyboard. Keeping the 't' key pressed is a bit more tricky. You will have to use a weight to hold the key down Hope this works for you Cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
show macro security setting in a cell | Excel Worksheet Functions | |||
Generating excel combinations | Excel Discussion (Misc queries) | |||
pivot table - hide details but show subtotal for calculated field | Excel Discussion (Misc queries) | |||
UDF and Calculation tree | Links and Linking in Excel | |||
Show a date based on today | Excel Worksheet Functions |