Shortcuts not working in Excel 2010

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

Shortcuts not working in Excel 2010
 
OliverM




Posts: 144
Joined: 2015-08-13
Will it work if you install all updates on Office 2010?


I updated to Excel 2010 14.0.7177.5000 32bit. But still no love.
Kind regards
Oliver
Posted 18 Dec, 2016 13:10:13 Top
Andrei Smolin


Add-in Express team


Posts: 14140
Joined: 2006-05-11
Hello Oliver,

I would like to access that PC remotely within the next 3.5 hours. Is this possible? If yes, I suggest using TeamViewer; in this case you'll need to send me your session ID and password to the support email address; see readme.txt.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 19 Dec, 2016 06:36:29 Top
OliverM




Posts: 144
Joined: 2015-08-13
Hi Andrei,

I have sent all details necessary.
Kind regards
Oliver
Posted 19 Dec, 2016 07:56:54 Top
Andrei Smolin


Add-in Express team


Posts: 14140
Joined: 2006-05-11
Thank you. Hopefully, you received my response.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 19 Dec, 2016 08:48:29 Top
OliverM




Posts: 144
Joined: 2015-08-13
That machine is very weird.

Both add-ins work ok after installation. They stop loading correctly, if I unload (COM Add-in => Uncheck Load at Startup) and then try to reload them again.
No errors no complaints in the logs.

The only thing which helps is uninstalling the add-ins completely and then reinstall them. Now everything works like expected to the point where I again uncheck the Load at Startup checkbox.

On a XL2013 machine I can unload/load the add-ins until the cows come home.
Kind regards
Oliver
Posted 19 Dec, 2016 10:11:18 Top
Andrei Smolin


Add-in Express team


Posts: 14140
Joined: 2006-05-11
Thank you for the details. I'll look into these tomorrow.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 19 Dec, 2016 10:32:11 Top
Andrei Smolin


Add-in Express team


Posts: 14140
Joined: 2006-05-11
Hello Oliver,

As far as I remember during the remote session you deleted adxloader.log and restarted Excel. This created an adxloader.log showing that the instance of the add-in module was created successfully. Still, the add-in itself was turned off and the COM Add-ins dialog showed something like "COM exception". I ask you to re-check the issue and confirm the above. Please provide the full text of the error message.

Did you try to repair Office on that machine?

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 20 Dec, 2016 08:28:53 Top
OliverM




Posts: 144
Joined: 2015-08-13
Hi Andrei,

I ran the repair option but no change.
I also installed VS2015 together with ADX.

My test add-in contains a ribbon tab (to indicate the add-in was successfully loaded) and 2 shortcut components. In order to debug it, I put breakpoints in the following event handlers:

- AddinModule_OnRibbonBeforeCreate
- AddinModule_OnRibbonBeforeLoad
- AddinModule_OnRibbonLoaded
- AddinModule_AddinInitialize
- AddinModule_AddinStartupComplete

I start the add-in and events fire in the above shown order.
Next I unload the add-in.
Next I reload the add-in but get 2 events only:

- AddinModule_AddinInitialize
- AddinModule_AddinStartupComplete

No ribbon related events fire.

If I do the same for XL2013 I first get this events:

- AddinModule_OnRibbonBeforeCreate
- AddinModule_OnRibbonBeforeLoad
- AddinModule_OnRibbonLoaded
- AddinModule_AddinInitialize
- AddinModule_AddinStartupComplete

After unloading and reloading the add-in I get all 5 events again, only the execution order has changed to:

- AddinModule_AddinInitialize
- AddinModule_AddinStartupComplete
- AddinModule_OnRibbonBeforeCreate
- AddinModule_OnRibbonBeforeLoad
- AddinModule_OnRibbonLoaded


Shouldn't I get the same number of events on both machines regardless of the XL version?
Kind regards
Oliver
Posted 20 Dec, 2016 11:23:11 Top
OliverM




Posts: 144
Joined: 2015-08-13
As far as I remember during the remote session you deleted adxloader.log and restarted Excel. This created an adxloader.log showing that the instance of the add-in module was created successfully. Still, the add-in itself was turned off and the COM Add-ins dialog showed something like "COM exception". I ask you to re-check the issue and confirm the above. Please provide the full text of the error message.


I can confirm the issue. After unloading/reloading the add-in the loader log is fine but the COM dialog shows an error message. Unfortunately the message is provided in German but it would translate to something like:
Not loaded. A runtime error occurred while trying to load the COM add-in.

If the reload issue was related to the 3 ribbon events not firing, the fact that the loader log shows no issues would make sense to me.
Kind regards
Oliver
Posted 20 Dec, 2016 12:00:26 Top
Andrei Smolin


Add-in Express team


Posts: 14140
Joined: 2006-05-11
Hello Oliver,

Thank you very much!

OliverM writes:
Next I reload the add-in but get 2 events only:


I would like to check 1) the add-in project that you use and 2) the .MSI installing the add-in built on your side. Would this be possible? If yes, please send them to the support email address.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 21 Dec, 2016 07:33:05 Top