![]() If you distribute such a workbook, with a worksheet containing a Solver model and a VBA module, you can simply add a reference to the Solver add-in (see below), activate the worksheet, and add one line to call the function SolverSolve in VBA. You can create this Solver model interactively if you wish. Using Solver VBA functions, you can display or completely hide the Solver dialog boxes, create or modify the choices of objective cell, constraints and decision variable cells, check whether an optimal solution was found, and produce reports.Ĭontrolling Solver can be as simple as adding one line to your VBA code! Each worksheet in a workbook may have a Solver problem defined, which is saved automatically with the workbook. You can control Solver from VBA, defining and solving problems just as you do interactively.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |