Solver add-in

[MG]

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?

 

[Norman Jones]

Hi MG,

See the recent thread:

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

 

[MG]

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