Forum Discussion
ADD IN TROUBLE
RALI-R I would suggest to add breakpoints in your code and step through it to see what part of the code causes the shutdown. Without your add-in and workbook, this is impossible to troubeshoot for us I'm afraid.
Thank you, Jan. Even just opening the workbook with reference to this add in caused it to open and close. But after your note, I added a subroutine to workbooks_open with a stop at the very first line. No go. Same thing happens.
I have been trying various tricks I can think of since I installed Office 2019 about 5 days ago. The same addin works fine with a couple of other workbooks without any issues. I tried renaming it, but no dice. At this point, I am out of ideas and looking for workarounds. The next step in my workaround is to see if I can programmatically add and remove addins.
What really baffles me is that the addin works fine even with this workbook if I add the reference after I open the workbook. I am open to any suggestions you have or anybody else has.
Regards,
RaliR
- Does opening the file run anything in the referenced add-in by any chance?
Yes. Indeed. That's why my original panic upon finding the problem eased a bit that I have been able to work around it. Many of my workbook functions are in the add in. Without access to the add in, I have to find a way to reincorporate it back into the workbook. I have been digging into the blogs to see if there is a way to not just add the add in, but add it to the reference. Any help or thoughts are appreciated.
- Why does the workbook need a reference to the add-in? Are you calling subs and functions from the add-in from within code in the workbook?
Yes. Indeed. That's why my original panic upon finding the problem eased a bit that I have been able to work around it. Many of my workbook functions are in the add in. Without access to the add in, I have to find a way to reincorporate it back into the workbook. I have been digging into the blogs to see if there is a way to not just add the add in, but add it to the reference. Any help or thoughts are appreciated.
- Without more detailed knowledge about your system it is very hard to advise, I'm sorry.