Run error occured

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

Run error occured
issue with debug 
Posts 1 - 10 of 14
First | Prev. | 1 2 | Next | Last 
Celvin Kattookaran




Posts: 8
 Joined: 2016-03-02
I can see a lot of similar issues in forums about run-time error occurred and COM adding was not loaded message. I tried registering-unregistering, closing EXCEL opening like hundred times. I don't see an adxloader.log. Is there an easier way to troubleshoot these issues?
Posted 02 Mar, 2022 16:17:59 Top
Celvin Kattookaran




Posts: 8
 Joined: 2016-03-02
The funny thing is it'll work if I launch EXCEL by itself and add the addin from COM Addins. However, if I start EXCEL from debug, it will not show up at all.
Posted 02 Mar, 2022 16:26:45 Top
Andrei Smolin


Add-in Express team


Posts: 18829
 Joined: 2006-05-11
Hello Celvin,

In the Add-in Express manual we provide section Troubleshooting; see the PDF file in the folder {Add-in Express}\Docs on your development PC. I recommend that you check this section when you run in an issue.

Is your add-in installed? If so, uninstall it, unregister your project and then register it again. Also, it might be so that you registered the project and then switched to a different configuration. If so, switch to the previous configuration and unregister the project.

The idea is. To load your add-in Add-in Express creates a registry key pointing to the location of the add-in assembly. Switching to another configuration builds the assembly in another location and Office can't load it.

Regards from Poland (CET),

Andrei Smolin
Add-in Express Team Leader
Posted 03 Mar, 2022 05:28:02 Top
Celvin Kattookaran




Posts: 8
 Joined: 2016-03-02
Thank you for the documentation hint. That helped to find where the log location is. Unfortunately, I cannot find the log file there.

The manifest file shows that it is generating logs. 

<?xml version="1.0" encoding="utf-8"?>
<configuration>
  <assemblyIdentity name="BDAAddin" imageRuntimeVersion="v4.0.30319" />
  <loaderSettings generateLogFile="true" shadowCopyEnabled="false" privileges="user" />
</configuration>


However, I did not find anything in the Temp directory with my product name. Even a search for adxloader didn't yield any results.

Yes, the product was uninstalled. I did register and un-register the vb project many times with no luck. I'm not sure what you meant by the configuration change. The only change that I can think of is the change in referenced dll files.

Thanks again for your help.
Posted 03 Mar, 2022 08:00:01 Top
Andrei Smolin


Add-in Express team


Posts: 18829
 Joined: 2006-05-11
Hello Celvin,

Since the log is missing, check section Troubleshooting add-in loading in the manual.

Regards from Poland (CET),

Andrei Smolin
Add-in Express Team Leader
Posted 04 Mar, 2022 05:56:42 Top
Celvin Kattookaran




Posts: 8
 Joined: 2016-03-02
Hmmm, so if I open EXCEL (not through Debug) then a log is generated and the addin is registered successfully. 

13:44:05:453 5016 16092 Querying the encryption provider.
13:44:05:453 5016 16092 The 'EncryptionProvider' interface is not supported.
13:44:05:453 5016 16092 Getting the dispid of the 'Dispose' method.
13:44:05:455 5016 16092 Success.
13:44:05:455 5016 16092 Getting the dispid of the 'InitializeLoaderService' method.
13:44:05:455 5016 16092 Success.
13:44:05:455 5016 16092 Invoking the 'InitializeLoaderService' method.
13:44:05:455 5016 16092 Success.
13:44:05:456 5016 16092 The instance of the managed add-in class has been created successfully.


So it is only an issue when EXCEL is started using Debug.
Posted 04 Mar, 2022 10:41:42 Top
Andrei Smolin


Add-in Express team


Posts: 18829
 Joined: 2006-05-11
Hello Celvin,

I suppose your add-in is registered wrongly. Unregister it and start the host application to make sure the add-in isn't there. If the add-in is still there, use info from section 'Locating COM add-ins in the registry' to find the location where your add-in is registered: find the CLSID key in the registry.

Make sure your add-in project follows instruction given in section 'Deploying a per-user Office extension via an MSI installer' or 'Deploying a per-machine Office extension via an MSI installer'. Register the add-in project and start debugging it.

Regards from Poland (CET),

Andrei Smolin
Add-in Express Team Leader
Posted 07 Mar, 2022 04:40:15 Top
Celvin Kattookaran




Posts: 8
 Joined: 2016-03-02
Here is what is going on. I've gone through the unregister/register process more than I could count.

Unregister and the add-in is not there.
[img]https://ibb.co/mcm81QY[/img]
Register from Visual Studio
[img]https://ibb.co/5hnR51x[/img]
Launching from host, the add-in is present and I can use it.
[img]https://ibb.co/CB2fnvw[/img]
However, when I use the Debug in Visual Studio. here is what happens.
[img]https://ibb.co/XW8rfmr[/img]
Posted 07 Mar, 2022 11:05:23 Top
Andrei Smolin


Add-in Express team


Posts: 18829
 Joined: 2006-05-11
Hello Celvin,

Check the registry keys to find the location where your add-in is registered. It may be registered or/and installed.

Is it possible that you switched from per-user add-in to per-machine or vice versa recently?

Regards from Poland (CET),

Andrei Smolin
Add-in Express Team Leader
Posted 08 Mar, 2022 10:17:25 Top
Celvin Kattookaran




Posts: 8
 Joined: 2016-03-02
Is there a way someone from support can look into this rather than getting one message a day?
Posted 09 Mar, 2022 17:07:36 Top

Posts 1 - 10 of 14
First | Prev. | 1 2 | Next | Last