In the Visual Basic Editor, with a module active, click References on the Tools menu, and then select Solver under Available References. In the Add-Ins dialog box, select Solver Add-in, and then click OK.Īfter you have enabled the Solver add-in, Excel will auto-install the Add-in if it is not already installed, and the Solver command will be added to the Analysis group on the Data tab in the ribbon.īefore you can use the Solver VBA functions in the Visual Basic Editor, you must establish a reference to the Solver add-in. In the Manage drop-down box, select Excel Add-ins, and then click Go.
In the Excel Options dialog box, click Add-Ins.
Before you can use the Solver VBA functions from VBA, you must enable the Solver add-in in the Excel Options dialog box.Ĭlick the File tab, and then click Options below the Excel tab.
0 kommentar(er)
