J
Jeanette
I am using another tool to change inputs to my Excel
spreadsheet and run Solver. I made a Macro and am able to
execute it without a person in the loop by having my
outside program execute it. The problem is that when the
maximum number of iterations or time is reached the "Show
Trial Solutions" dialogue box comes up and requires a user
input. I would like it to always stop and go on to my
next case. This dialogue box kills my automation. Is
there anyway to suppress this or have it automatically
enter stop?
spreadsheet and run Solver. I made a Macro and am able to
execute it without a person in the loop by having my
outside program execute it. The problem is that when the
maximum number of iterations or time is reached the "Show
Trial Solutions" dialogue box comes up and requires a user
input. I would like it to always stop and go on to my
next case. This dialogue box kills my automation. Is
there anyway to suppress this or have it automatically
enter stop?