Error with multiple Excel PlugIns

Add-in Express™ Support Service
That's what is more important than anything else

Error with multiple Excel PlugIns
2 Excel PlugIns suddenly give Error when exiting Excel 
Subscribe
George Spears




Posts: 80
 Joined: 2010-05-06
Delphi 12.2 with all patches. Latest version of AddInExpress. 64 bit only. I have 3 Excel 64 bit plugins that I have written; P, P2 and W. I recently upgraded from D11.3 and an older version of AddIn Express. All 3 plugIns worked fine, and they worked together without issue.

I upgraded to latest Delphi and AddIn Express. I had to make some minor changes to my code after upgrading, but it was not related to AddIn Express. I recompiled P2 and W, but NOT P. I am now seeing compatibility issues with the 3 plugIns. Each works by itself without error. The error is WHEN EXITING Excel, 'Runtime error 231 at <memory address>. This only occurs when completely exiting the last instance of Excel. In my testing, I am now starting excel, just starting the executable, and then immediately exiting. I am NOT loading any files or new workbooks. I get this error around 10-12 times. All plusIns exit fine when ONLY they are loaded. P and P2 combo exits fine. P and W exists fine. Only the combination of P2 and W show the error when exiting. When Googling this, a possible reason is VBA code, but I am not even loading a worksheet. How do I go about finding where this is happening? I have tried starting the W app in Delphi and Debugging. I get the error when existing, but I am at a lost what to do with it. I tried going to that memory address, but can't identify anything.

I have tried unregistering and re-registering both the P2 and W plugIns.
I have tried going the online version of "Repair Microsoft Office".
I have created a new pluging called TEST. TEST and P2 work fine together. TEST and W work fine together.
I have ran W within Delphi debug. I have included the CallStack, which shows the error is occuring in 'UnregisterUnitVersion'. [img]https://photos.google.com/photo/AF1QipMHa2UE83wso4vRVbUVGGWNkW9Ws8-KoOikWea1[/img]Any ideas?
Posted 29 Jan, 2025 13:17:50 Top
Andrei Smolin


Add-in Express team


Posts: 19068
 Joined: 2006-05-11
Hello George,

I've responded to your previous email; please check your Inbox and Junk Email.

Regards from Poland (GMT+2),

Andrei Smolin
Add-in Express Team Leader
Posted 30 Jan, 2025 12:36:28 Top