Solver function from VBA

ColourfulFigsnDiags · Sep 8, 2005

Anyone know how to execute the solver function from VB? I tried recording a macro as I used solver, but when I run the macro it highlights the "SolverOK" command and comes up with an error saying "compile error: Sub or function not defined."

Any help would be greatly appriciated!

ColourfulFigsnDiags · Sep 8, 2005

Sorry ... figured it out ... if all else fails RTFM

"Before you use this function, you must establish a reference to the Solver add-in. With a Visual Basic module active, click References on the Tools menu, and then select the Solver.xla check box under Available References. If Solver.xla doesn't appear under Available References, click Browse and open Solver.xla in the \Office\Library\Solver\ subfolder."

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Solver function from VBA

ColourfulFigsnDiags

Chemical

ColourfulFigsnDiags

Chemical

Similar threads

Part and Inventory Search

Sponsor