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?