COM add-in won't load when Excel is run as administrator

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

COM add-in won't load when Excel is run as administrator
COM add-in won't load when Excel is run as administrator 
David Jones


Guest


Hi there

We have an add-in that consists of an XLL (for in cell functions) and a COM add-in (for a ribbon).

If we install this as the local user, then run Excel as the local user, everything works fine.

When I install as the local user, then try to run Excel as administrator, the COM add-in doesn't load. If I go to Manage COM Add-ins and tick the checkbox next to our add-in name, I get the error:

Load Behavior: Not loaded. A runtime error occurred during the loading of the COM Add-in.

Any ideas? Is it possible to get this working?

Thanks

David
Posted 23 Apr, 2018 08:56:26 Top
Andrei Smolin


Add-in Express team


Posts: 19122
 Joined: 2006-05-11
Hello David,

It isn't possible. Here's a citation from http://blogs.msdn.com/b/cjacks/archive/2008/06/06/per-user-com-registrations-and-elevated-processes-with-uac-on-windows-vista-sp1.aspx:


So, the behavior beginning with Windows Vista SP1 for per user COM registration is:

UAC Disabled - You see per-user COM classes
UAC Enabled - Not Elevated - You see per-user COM classes
UAC Enabled - Elevated - You do not see per-user COM classes


A COM add-in is a COM class above. In your case, the COM add-in is per user because an XLL add-in must be per user.


Andrei Smolin
Add-in Express Team Leader
Posted 23 Apr, 2018 09:25:04 Top
David Jones


Guest


Makes sense - thanks very much, Andrei.
Posted 24 Apr, 2018 04:27:17 Top
Andrei Smolin


Add-in Express team


Posts: 19122
 Joined: 2006-05-11
You are welcome!


Andrei Smolin
Add-in Express Team Leader
Posted 24 Apr, 2018 04:39:54 Top