Windows XP, Excel 2003

Hi people,

I'm trying to use Solver in an add-in. I set up a reference as
directed in my book and everything worked fine until I closed Excel and
tried to reopen, at which point I got one of those windows that say that
Excel has experienced a problem and had to close, do you want to send an
error report, etc. Then, since the "Restart Excel" box was clicked, I
got another message after dismissing the first that tells me that the
last time Excel was opened with my add-in enabled, it experienced a
problem and do I want to disable it so Excel will open?
If I disable the add-in, open Excel, then reactivate it, everything
works fine. If I delete the Solver reference, I can close and reopen
Excel as many times as I wish without a problem (of course, some
features of my add-in won't work). Moreover, if I add a reference to
another Excel add-in (analysis toolpak in this case - atpvbaen.xla),
everything works just fine! It's only the Solver reference that messes
up! I am perplexed. If anyone has any light to shed on this issue,
please do!

Thanks,
Allison


--
Stacy35216
------------------------------------------------------------------------
Stacy35216's Profile: http://www.excelforum.com/member.php...o&userid=15952
View this thread: http://www.excelforum.com/showthread...hreadid=489495