Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calling Solver from VBA
I am calling Solver about 6,000 times in a subroutine.
Occasionally, due to the size of the problem I am solving, Solver will reach the maximum time limit. I would like to insert some code so that if Solver reaches the maximum time limit, that it just uses the best solution it has found so far and moves on. Increasing the time limit is not an option, since I need the subroutine to finish overnight and have set the time limit accordingly. Can anyone help? Thanks very much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CALLING PARTICULAR CHARTS | Excel Discussion (Misc queries) | |||
HELP!!!! Calling a sub from Workbook_BeforeSave | Excel Discussion (Misc queries) | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Calling an Add-In | Excel Discussion (Misc queries) | |||
Calling the Solver via a subroutine | Excel Programming |