In all cases (Windows 7 or 8.1 or 10) the user logs into Windows as a member of the "Local Administrators" group. This behaviour happens no matter wether the Add-in is registered as a Per-User Add-in or as a All-Users Add-in. If Excel is started with normal privledges on Windows 10, the Add-in does not load. However, on Windows 10, the Task Pane Add-In will only load if Excel is started with elevated / administrator privileges (ie Right Mouse Click > "Run As Administrator") We have created an Excel Task Pane Add-In that loads perfectly on Windows 7 and 8.1 in Office 2103 and Add-in Express 7. This situation is happening on two sepperate development computers running the same software setup.ġ) Is this the correct behaviour of Excel loading COM Addins on Windows 10 ?Ģ) Is there anyway to get Excel to load the COM Addin without first having to select the Excel Shortcut and then select "Run As Administrator" ? The COM addin was registered from within Visual Studio 2015 using the Add-In Express > Register menu option. We are also using Visual Studio 2015, Office Pro 2016 and Add-in Express 8 on Windows 10 Enterprise 64bit The only way that I can get the AddIn.Connect command in VBA to succeed ( and to display the task pane) is to Right Mouse on the Excel Shortcut and select "Run As Administrator". Under Windows 10 Pro / Ent, the loading of the COM Addin will fail on the AddIn.Connect command in VBA if Excel is started normally even though the logged in user belongs to the Windows "Administrators" Group and the shortcut for Excel on the Windows Start menu is set to "Run as Administrator". Our Excel COM Addin would load fine on Windows 7 and Windows 8.1 without starting Excel "As Administrator".
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |