The easy part, vba code with your solver contrain settings.
The easiest way to write a code like this is:
Open solver, clear all data from solver by pressing button "Reset All" click "ok" and close solver.
The go to "Developers" tab and click "Record Macro"
Start doing all steps to run solver i.e. click on data tab and fill in all the values you normaly do and run solver if you like. Close solver and go back to the "Developers" tab and click "Stop Recording".
You now have a macro recording of the solver set up. You don't get the extras like
and
and you also get a second setup of line
before the "SolverSolve" line, but you don't need this so delete it as it makes code more easy to read.
Will have a go at you other questions ans see if i can do something there as well.
Alf
Bookmarks