Hi everyone,

I posted a question yesterday on this topic and got some useful replies
(thanks :-)). I have done a bit more digging and found the cause of the crash.

My add-in contains a reference to the solver and it seems that solver.xla
needs an open workbook before it opens - if none is open it will cause Excel
to crash.

So, it seems the order of things is this:

1. Excel opens
2. Excel starts up my add-in
3. My add-in opens a blank workbook
4. My add-in opens solver.xla

If I don't do step 3 I get the crash.

So, it seems that my add-in passes control to the solver.xla. After
solver.xla has opened (and presumably checked for an open workbook) does
control pass back to my add-in? And if it does, can I catch it and get it to
close the workbook it opened in step 3?

I guess what I'm after is some sort of AfterOpeningReference declaration.
Any ideas?

TIA

big t