B
BigHairyUglyGuy
Q. I'm trying to run the Solver in Excel via a macro. But as soon as my
code calls a Solver function, I get the message "Sub or Function not
defined". What am I doing wrong?
I found the website www.solver.com which had the following answer in the
FAQ page http://www.solver.com/suppfaqhint.htm
A. You need a reference to the Solver add-in in VBA. First make sure that
you've displayed the Solver Parameters dialog at least once in your Excel
session. Then open the Visual Basic Editor (Alt-F11), select Tools
References, and check the box next to Solver.
That question answers my problem exactly. It does work. The problem is
that I have to do this every time I start a new Excel session. So I'm
looking for a way to set it up so they don't have to do it every time. Any
ideas how to fix it? Would changing the set up in Excel help?
code calls a Solver function, I get the message "Sub or Function not
defined". What am I doing wrong?
I found the website www.solver.com which had the following answer in the
FAQ page http://www.solver.com/suppfaqhint.htm
A. You need a reference to the Solver add-in in VBA. First make sure that
you've displayed the Solver Parameters dialog at least once in your Excel
session. Then open the Visual Basic Editor (Alt-F11), select Tools
References, and check the box next to Solver.
That question answers my problem exactly. It does work. The problem is
that I have to do this every time I start a new Excel session. So I'm
looking for a way to set it up so they don't have to do it every time. Any
ideas how to fix it? Would changing the set up in Excel help?