I would like to be able to change the max time limit for the Frontline Analytic solver add-in in excel direct with my VBA code instead of having to go into the solver. I would like to have a cell in my worksheet where I enter the time I want the solver to run (exemple : 120 seconds) and when I run my code, it changes automaticly the max time limit.
I tried the
method but it doesn't work since I am not using the built-in solver in Excel.
Secondly, I would like for the code to automaticly press the "Stop" button once the time limit has been reached since I am running a loop and performing multiple optimizations one after the other.
Thank you
Bookmarks