macro involving solver

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. Is it possible to create a macro which involves using solver? I tried, but got an error.
 
Before you use the solver within a macro, you must
establish a reference to the Solver add-in.

With a Visual Basic module active, click References on the
Tools menu, and then select the Solver.xla check box under
Available References.

If Solver.xla doesn't appear under Available References,
click Browse and open Solver.xla in the \Office\Library
subfolder.

Cheers
Nick


-----Original Message-----
Hi. Is it possible to create a macro which involves
Click to expand...
using solver? I tried, but got an error.
 
You must log in or register to reply here.

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

Similar Threads

Excel 2007: Help creating a macro that will run Solver? 3
Macros involving SOLVER... function 5
Will Solver do the job? 7
Solver not found 1
Excel Solver, Answer Report 4
Solver 2
Solver Error - an unexpected internal error has occurred 1
Solver or not Solver 4

Back
Top