Excel - Solver - Macro
Excel - Solver - Macro
(OP)
Would appreciate some help on the following:
Creating a Macro that uses the Excel "Solver" function. When I run the Macro it returns with a notice
"Compile error:
Sub or Function not defined."
It highlights "SolverOK" in the code.
If someone could sugest a solution it would be appreciated.
Thanks
Creating a Macro that uses the Excel "Solver" function. When I run the Macro it returns with a notice
"Compile error:
Sub or Function not defined."
It highlights "SolverOK" in the code.
If someone could sugest a solution it would be appreciated.
Thanks





RE: Excel - Solver - Macro
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Excel - Solver - Macro
Do the following:
(1) Get into VBA.
(2) Take Tools>References>Browse.
(3) You now need to locate the Solver code. With a "standard" installation of Office 10, you will find it in the directory
C:\Program Files\Microsoft Office\Office10\Library\Solver
so navigate your way to that location.
(4) The entity you wish to select is SOLVER.XLA and this will normally not be visible unless you activate the "all files" view.
(5) Select SOLVER.XLA and hit "open".
You will now return to the main references screen, where you should see the SOLVER has been added to the list and has been activated.
Other versions of Excel will be basically similar, mutatis mutandis.
RE: Excel - Solver - Macro
Cheers
Greg Locock
Please see FAQ731-376: Eng-Tips.com Forum Policies for tips on how to make the best use of Eng-Tips.
RE: Excel - Solver - Macro