Add-in crashing Excel
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
|