I have a solver within a macro which works fine on my computer, however, when
it is used on a different computer (without solver added) the macro falls
down. After overcoming a series of errors it is possible to add the solver
but it is not ideal. Is there a way to automatically add the solver when the
file is opened to avoid this problem?

Hi MG,

See the recent thread:

Tools References... in Excel Programming
http://tinyurl.com/5et64a




---
Regards.
Norman


"MG" wrote in message
...
I have a solver within a macro which works fine on my computer, however,
when
it is used on a different computer (without solver added) the macro falls
down. After overcoming a series of errors it is possible to add the
solver
but it is not ideal. Is there a way to automatically add the solver when
the
file is opened to avoid this problem?

Thanks very much for that Norman. Code works just fine.

"MG" wrote:

I have a solver within a macro which works fine on my computer, however, when
it is used on a different computer (without solver added) the macro falls
down. After overcoming a series of errors it is possible to add the solver
but it is not ideal. Is there a way to automatically add the solver when the
file is opened to avoid this problem?