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?

I've outlined some alternate approaches on my web site:

http://peltiertech.com/Excel/SolverVBA.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"BigHairyUglyGuy" wrote in
message ...
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?