Forum Discussion
ADD IN TROUBLE
I have a problem with an addin that I developed myself and have been using it for about 6 months. I just upgraded to MS Office 2019. With one particular workbook, this addin seems to cause a problem, in that the workbook opens briefly and shuts down. However, if I remove reference to the addin, open the workbook, add the reference for the addin back, lo and behold, the full functionality is there. However if I saved this workbook with the addin referenced in and then open, it does not work. So right now I am working this workaround by removing the addin reference and save and add it back when I need. Any thoughts, ideas?
Thank you,
RaliR
7 Replies
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?
