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 |
All times are GMT +1. The time now is 02:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com