Hi,

I'm controlling Solver via VBA. But to do this you must add in SOLVE
via the Tools References within VBA. If you don't do this first th
macro crashes. However, as I'm going to give this worksheet to othe
people is there a way to either automatically add SOLVER in within VB
or to check it it's loaded?

Any help would be appreciated.

Thanks

Chri

--
Chris
-----------------------------------------------------------------------
ChrisK's Profile: http://www.excelforum.com/member.php...fo&userid=1637
View this thread: http://www.excelforum.com/showthread.php?threadid=27751