Excel Automation UDF addin not loading or present

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

Excel Automation UDF addin not loading or present
 
William Hughes


Guest


We are working with a client who is unable to run the automation UDFs associated with our Excel add-in. The COM user interface portion of the add-in loads fine. The symptoms are very similar to what was reported in the forum topic

https://www.add-in-express.com/forum/read.php?FID=5&TID=14881

It is not showing at all in the Excel File-Options-Add-ins section including the inactive and disabled areas. The only difference between our situation and the previous forum topic is we have an automation excel add-in not an XLL. I'm trying to confirm the exact version with the client but based on the WindowsApps path for the Excel.exe file I believe this may also be Excel Home and Business July 25,2018 release.

The logs are shown below (with the application and path names changed to MyAddin). We are running the latest Addin Express version. I did not see any errors and the add-in runs fine in the same release in Microsoft Office Professional Plus.

Thanks in advance for any help or suggestions





Add-in Express Loader Log File: 08/02/2018 17:06:39:737

Startup directory: C:\Program Files (x86)\MyAddin\
Loader version: 9.1.4620.0
Operating System: Microsoft Windows 10 Professional (build 16299), 64-bit
Process Owner: Administrator
Command Line: "C:\Program Files\WindowsApps\Microsoft.Office.Desktop.Excel_16030.10325.20082.0_x86__8wekyb3d8bbwe\Office16\EXCEL.exe" "C:\ProgramData\MyFolder\MyAddin\Welcome.xls"
Run 'As Administrator': No
Process Elevated: No
Integrity Level: Medium
UAC (User Account Control): On
------------------------------------------------------------------------
17:06:39:738 3120 18760 Start.
17:06:39:739 3120 18760 Creating a new instance of the add-in loader.
17:06:39:739 3120 18760 Loading mscoree.dll
17:06:39:739 3120 18760 Success.
17:06:39:739 3120 18760 Loading the configuration from the system registry.
17:06:39:740 3120 18760 Getting the latest CLR version.
17:06:39:740 3120 18760 The latest CLR version is 'v4.0.30319'.
17:06:39:740 3120 18760 The configuration has been loaded successfully.
17:06:39:740 3120 18760 Runtime version: v4.0.30319.
17:06:39:740 3120 18760 Assembly name: MyAddin, PublicKeyToken=C069709382340A6C.
17:06:39:740 3120 18760 Class name: MyAddin.AddinModule.
17:06:39:740 3120 18760 Registry key: CLSID\{E8F5DB4A-3473-4730-9A58-85795F8436C9}.
17:06:39:740 3120 18760 Attempting to create a new instance of the managed add-in class: CLR - v4.0.30319
17:06:39:740 3120 18760 Loading CLR: v4.0.30319.
17:06:39:741 3120 18760 Calling CLRCreateInstance method.
17:06:39:741 3120 18760 Success.
17:06:39:741 3120 18760 Calling GetRuntime method.
17:06:39:741 3120 18760 Success.UDF
17:06:39:741 3120 18760 Checking if the hosting API of .NET Framework v4.0 beta is installed.
17:06:39:750 3120 18760 The hosting API is up to date.
17:06:39:750 3120 18760 Calling SetDefaultStartupFlags method.
17:06:39:750 3120 18760 Success.
17:06:39:750 3120 18760 Calling GetInterface method for the CorRuntimeHost interface.
17:06:39:750 3120 18760 Success.
17:06:39:750 3120 18760 Starting CLR...
17:06:39:750 3120 18760 Success.
17:06:39:750 3120 18760 Getting the CLR version.
17:06:39:750 3120 18760 The CLR v4.0.30319 has been initialized successfully.
17:06:39:750 3120 18760 Creating a new domain setup.
17:06:39:752 3120 18760 Success.
17:06:39:752 3120 18760 Getting the add-in directory.
17:06:39:752 3120 18760 Success. The directory is 'C:\Program Files (x86)\MyAddin\'
17:06:39:753 3120 18760 The configuration file is 'C:\Program Files (x86)\MyAddin\MyAddin.dll.config'
17:06:39:753 3120 18760 The 'shadow copy' is disabled.
17:06:39:753 3120 18760 Creating a new application domain.
17:06:39:757 3120 18760 Success.
17:06:39:757 3120 18760 Creating an instance of the managed class. Assembly identity: 'MyAddin, PublicKeyToken=C069709382340A6C'
17:06:40:230 3120 18760 Success.
17:06:40:230 3120 18760 Unwrapping the managed class.
17:06:40:244 3120 18760 Success.
17:06:40:244 3120 18760 Querying the add-in extensibility.
17:06:40:244 3120 18760 Success.
17:06:40:244 3120 18760 Querying the custom task panes.
17:06:40:244 3120 18760 Success.
17:06:40:244 3120 18760 Querying the ribbon extensibility.
17:06:40:244 3120 18760 Success.
17:06:40:244 3120 18760 Querying the form regions.
17:06:40:244 3120 18760 Success.
17:06:40:244 3120 18760 Querying the encryption provider.
17:06:40:244 3120 18760 The 'EncryptionProvider' interface is not supported.
17:06:40:244 3120 18760 Getting the dispid of the 'Dispose' method.
17:06:40:248 3120 18760 Success.
17:06:40:248 3120 18760 Getting the dispid of the 'InitializeLoaderService' method.
17:06:40:248 3120 18760 Success.
17:06:40:248 3120 18760 Invoking the 'InitializeLoaderService' method.
17:06:40:249 3120 18760 Success.
17:06:40:249 3120 18760 The instance of the managed add-in class has been created successfully.


Add-in Express Registrator Log File: 08/02/2018 17:06:36

Installation directory: C:\Program Files (x86)\MyAddin\
Registrator version: 9.1.4620.0
Operating System: Microsoft Windows 10 Professional (build 16299), 64-bit
Process Owner: Administrator
Command Line: "C:\Program Files (x86)\MyAddin\adxregistrator.exe" /install="MyAddin.dll" /privileges=user
Run 'As Administrator': No
Process Elevated: No
Integrity Level: Medium
UAC (User Account Control): On
--------------------------------------------------------------
17:06:36 0508 Starting the add-in registration process.
17:06:36 0508 Loading mscoree.dll
17:06:36 0508 Success.
17:06:36 0508 .NET Framework installation directory:
17:06:36 0508 The latest version of .NET Framework: 'v4.0.30319'
17:06:36 0508 Loading CLR: v4.0.30319.
17:06:36 0508 Calling CLRCreateInstance method.
17:06:36 0508 Success.
17:06:36 0508 Calling GetRuntime method.
17:06:36 0508 Success.
17:06:36 0508 Checking if the hosting API of .NET Framework v4.0 beta is installed.
17:06:36 0508 The hosting API is up to date.
17:06:36 0508 Calling GetInterface method for the CorRuntimeHost interface.
17:06:36 0508 Success.
17:06:36 0508 Starting CLR...
17:06:36 0508 Success.
17:06:36 0508 Getting the CLR version.
17:06:36 0508 The CLR v4.0.30319 has been initialized successfully.
17:06:36 0508 Creating a new domain setup.
17:06:36 0508 Success.
17:06:36 0508 Getting the add-in directory.
17:06:36 0508 Success. The directory is 'C:\Program Files (x86)\MyAddin\'
17:06:36 0508 The 'shadow copy' is disabled.
17:06:36 0508 Creating a new application domain.
17:06:36 0508 Success.
17:06:36 0508 Getting the base directory for the domain.
17:06:36 0508 Success. The directory is 'C:\Program Files (x86)\MyAddin\'.
17:06:36 0508 Searching for the Add-in Express core library.
17:06:36 0508 Success. The 'AddinExpress.MSO.2005.dll' file is found.
17:06:36 0508 Creating an instance of the 'AddinExpress.Deployment.ADXRegistrator' class.
17:06:36 0508 Assembly identity is 'AddinExpress.MSO.2005'.
17:06:36 0508 Success.
17:06:36 0508 Unwrapping the instance of the 'AddinExpress.Deployment.ADXRegistrator' class.
17:06:36 0508 Success.
17:06:36 0508 Calling the managed registration procedure (DISPID = 1610743823).
17:06:36 1028 32 bits. The 'HKCU\Software\Microsoft\Office\Excel\AddIns\MyAddin.AddinModule' registry key was created successfully for the 'MyAddin.AddinModule' class: LoadBehavior=3
17:06:36 1028 32 bits. The 'HKCU\CLSID\{e8f5db4a-3473-4730-9a58-85795f8436c9}\InprocServer32' registry key was created successfully for the 'MyAddin.AddinModule' class: C:\Program Files (x86)\MyAddin\adxloader.dll
17:06:36 1028 64 bits. The 'HKCU\Software\Microsoft\Office\Excel\AddIns\MyAddin.AddinModule' registry key was created successfully for the 'MyAddin.AddinModule' class: LoadBehavior=3
17:06:36 1028 64 bits. The 'HKCU\CLSID\{e8f5db4a-3473-4730-9a58-85795f8436c9}\InprocServer32' registry key was created successfully for the 'MyAddin.AddinModule' class: C:\Program Files (x86)\MyAddin\adxloader64.dll
17:06:36 0508 Registration success.
17:06:36 0508 The add-in registration process is completed with HRESULT = 0.
Posted 02 Aug, 2018 20:37:08 Top
Andrei Smolin


Add-in Express team


Posts: 18844
Joined: 2006-05-11
Hello William,

Start Excel, open File |Account, and in the version string check if that Excel is a Click-to-Run version, not an Office Store version.


Andrei Smolin
Add-in Express Team Leader
Posted 03 Aug, 2018 01:57:48 Top
William Hughes


Guest


Andre,

Thanks for your reply

The product is Microsoft Office 365 Business

Version 1807 (Build 10325.20082)
Posted 03 Aug, 2018 09:52:59 Top
Andrei Smolin


Add-in Express team


Posts: 18844
Joined: 2006-05-11
Hello William,

Please send me the following screenshots from that machine to the support email address (see {Add-in Express installation folder}\readme.txt):

1. Add-ins dialog showing any loaded Excel add-in selected
2. File | Options | Add-ins showing any loaded Excel add-in selected
3. Also please capture the following pages of the Trust Center (File | Options | Trust Center | Trust Center Settings):
- a. Trusted Locations
- b. Trusted Documents
- c. Add-ins
- d. ActiveX Settings
- e. Macro Settings
- f. File Block Settings (make sure the full list is visible)


Andrei Smolin
Add-in Express Team Leader
Posted 06 Aug, 2018 05:23:37 Top
William Hughes


Guest


We worked with this client to retrieve this information. The screen shot he sent from File - Options - Add-ins shows our COM User Interface Add-in but no UDF automation Add-in is active, inactive or disabled. Our add-in is the only active add-in listed. Its as if Excel is completely ignoring the HKCU registry settings being set up.

Nothing is out of the ordinary for the other settings.

The default is set for File Blocking and Excel add-ins blocking is not checked.

For ActiveX settings: "Prompt me before enabling all controls with minimal restrictions."

For Macro settings: "Disable all macros with notification"

The default values are set up under Trusted Files and Trusted Locations.

I've evaluated a Click to Run version of Office 365 for Business on a test machine and did not have any issue such as this. I've tried all combinations of the Trust Center and could not replicate this problem. But the client is using a Windows Store version, not click to run. Are you aware of any compatibility issues related to this difference.
Posted 07 Aug, 2018 15:43:59 Top
Andrei Smolin


Add-in Express team


Posts: 18844
Joined: 2006-05-11
Hello William,

William Hughes writes:
But the client is using a Windows Store version, not click to run. Are you aware of any compatibility issues related to this difference.


We did see a Windows Store version not loading XLL add-ins. In a moment I'll use Help | Contact Support in Excel to write to Microsoft asking them to check this.


Andrei Smolin
Add-in Express Team Leader
Posted 08 Aug, 2018 07:42:21 Top
William Hughes


Guest


Any update on this?
Posted 13 Aug, 2018 09:28:41 Top
Andrei Smolin


Add-in Express team


Posts: 18844
Joined: 2006-05-11
Hello William,

The only new thing is: I did write to Microsoft. What's left is to wait for them to fix this as contacting them is a one-way road: I don't even know whether they read my message or not. I believe they did read but I cannot even suppose how the reacted as there's no way for me to get their reaction.


Andrei Smolin
Add-in Express Team Leader
Posted 13 Aug, 2018 10:40:55 Top
William Hughes


Guest


Could you confirm that you've been able to reproduce this problem? Is the problem is different than the issue for XLL UDFs where Add-in express had to be updated?
Posted 13 Aug, 2018 10:58:05 Top
Andrei Smolin


Add-in Express team


Posts: 18844
Joined: 2006-05-11
I'll provide our test results tomorrow.


Andrei Smolin
Add-in Express Team Leader
Posted 13 Aug, 2018 11:05:39 Top