Accessing the Solver Add-in in VBA

  • Thread starter BigHairyUglyGuy
  • Start date
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top