Jul 15 2019 04:58 AM
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
Jul 15 2019 05:05 AM
@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.
Jul 15 2019 06:56 AM
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
Jul 15 2019 07:16 AM
Jul 15 2019 08:01 AM
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.
Jul 15 2019 08:10 AM
Jul 15 2019 09:48 AM
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.
Jul 22 2019 05:20 AM