Solver & VBA

[Magic_Doctor]

Hello everyone,

Is it possible to use the "Solver" by means of a macro?

The "Solver" works perfectly well when you activate it from the sheet. However, when we want to start it using a macro, it never works! ...
Curiously when recording a macro by using the "Solver", it not written in English but in Spanish (my version of Excel 2007 is in Spanish). I was just trying to rewrite VBA language (ie English) that had recorded the macro, it still does not work ...

Thank you in advance for any comments.

[shg]

To use Solver in VBA, you need to set a reference:

In the VBE, Tools > References, browse to C:\Program Files\Microsoft Office\OFFICExx\Library\SOLVER, change the file type dropdown to *.xls, *.xla, and pick SOLVER.XLA