Load XLL Addin - Add-in Express .NET forum

Mirko Neubert

Posts: 85
Joined: 2007-09-24

Hallo,
we have got an client, with our Excel-Add-in, who cant use it.
Com-Add-in is visible and works.
Xll-add-in (function) did not work and the functions are not visible.
in the Excel-Add-In options we see adxloader.BPS_Functions normaly it is BPS_Functions
It is a Windows 10 64 bit PC and Excel 2010 32 bit
the user how had installed is local administrator

We tried also an other Installationdirectory.

Have you a tip why it doesn't work

Kind regards
Mirko

adxloader.log
------------------

Add-in Express Loader Log File: 10/09/2017 16:58:10

Startup directory: C:\Program Files (x86)\BPS-ONE\BPS2Excel\
Loader version: 6.7.3062.0
Operating System: Microsoft Professional (build 9200), 64-bit
Process Owner: Administrator
Command Line: "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE"
Run 'As Administrator': No
Process Elevated: No
Integrity Level: Medium
UAC (User Account Control): On
------------------------------------------------------------------------
16:58:10 1608 10708 Start.
16:58:10 1608 10708 Reading the registry key 'HKEY_CLASSES_ROOT\CLSID\{DA188FA0-E5E2-4AB7-A647-2FFBA676B6DF}'
16:58:10 1608 10708 Success. The registry key 'HKEY_CLASSES_ROOT\CLSID\{DA188FA0-E5E2-4AB7-A647-2FFBA676B6DF}' is closed.
16:58:10 1608 10708 Converting the '{4BA250A6-8BCA-46A6-982A-F340081187C3}' CLSID from string.
16:58:10 1608 10708 Success.
16:58:10 1608 10708 Attempting to get the class object by the '{4BA250A6-8BCA-46A6-982A-F340081187C3}' CLSID.
16:58:10 1608 10708 Success.
16:58:10 1608 10708 Creating a new instance of the add-in loader.
16:58:10 1608 10708 Loading mscoree.dll
16:58:10 1608 10708 Success.
16:58:10 1608 10708 Loading the configuration from the system registry.
16:58:10 1608 10708 Getting the latest CLR version.
16:58:10 1608 10708 The latest CLR version is 'v4.0.30319'.
16:58:10 1608 10708 The configuration has been loaded successfully.
16:58:10 1608 10708 Runtime version: v2.0.50727.
16:58:10 1608 10708 Assembly name: BPS2Excel, PublicKeyToken=F78C733F69BF0CBF.
16:58:10 1608 10708 Class name: Denzhorn.BPS2Excel.BPS2Excel.
16:58:10 1608 10708 Registry key: CLSID\{DA188FA0-E5E2-4AB7-A647-2FFBA676B6DF}.
16:58:10 1608 10708 Attempting to create a new instance of the managed add-in class: CLR - v2.0.50727
16:58:10 1608 10708 Loading CLR: v2.0.50727.
16:58:10 1608 10708 Calling CLRCreateInstance method.
16:58:10 1608 10708 Success.
16:58:10 1608 10708 Calling GetRuntime method.
16:58:10 1608 10708 Success.
16:58:10 1608 10708 Checking if the hosting API of .NET Framework v4.0 beta is installed.
16:58:10 1608 10708 The hosting API is up to date.
16:58:10 1608 10708 Calling GetInterface method for the CorRuntimeHost interface.
16:58:10 1608 10708 Success.
16:58:10 1608 10708 Starting CLR...
16:58:10 1608 10708 Success.
16:58:10 1608 10708 Getting the CLR version.
16:58:10 1608 10708 The CLR v2.0.50727 has been initialized successfully.
16:58:10 1608 10708 Creating a new domain setup.
16:58:10 1608 10708 Success.
16:58:10 1608 10708 Getting the add-in directory.
16:58:10 1608 10708 Success. The directory is 'C:\Program Files (x86)\BPS-ONE\BPS2Excel\'
16:58:10 1608 10708 The 'shadow copy' is enabled.
16:58:10 1608 10708 Creating a new application domain.
16:58:10 1608 10708 Success.
16:58:10 1608 10708 Unwrapping the managed class.
16:58:10 1608 10708 Success.
16:58:10 1608 10708 Querying the add-in extensibility.
16:58:10 1608 10708 Querying the custom task panes.
16:58:10 1608 10708 Querying the ribbon extensibility.
16:58:10 1608 10708 Success.
16:58:10 1608 10708 Querying the form regions.
16:58:10 1608 10708 Success.
16:58:10 1608 10708 Getting the dispid of the 'Dispose' method.
16:58:10 1608 10708 Success.
16:58:10 1608 10708 The managed add-in class has been created successfully.

adxregistrator.log
---------------------

Add-in Express Registrator Log File: 10/09/2017 16:57:15

Installation directory: C:\Program Files (x86)\BPS-ONE\BPS2Excel\
Registrator version: 6.7.3062.0
Operating System: Microsoft Professional (build 9200), 64-bit
Process Owner: System
Command Line: "C:\Program Files (x86)\BPS-ONE\BPS2Excel\adxregistrator.exe" /Install="BPS2Excel.dll" /privileges=administraor
Run 'As Administrator': Yes
Process Elevated: Yes
Integrity Level: System
UAC (User Account Control): On
--------------------------------------------------------------
16:57:15 0620 Starting the add-in registration process.
16:57:15 0620 Loading mscoree.dll
16:57:15 0620 Success.
16:57:15 0620 .NET Framework installation directory:
16:57:15 0620 The latest version of .NET Framework: 'v4.0.30319'
16:57:15 0620 Loading CLR: v4.0.30319.
16:57:15 0620 Calling CLRCreateInstance method.
16:57:15 0620 Success.
16:57:15 0620 Calling GetRuntime method.
16:57:15 0620 Success.
16:57:15 0620 Checking if the hosting API of .NET Framework v4.0 beta is installed.
16:57:15 0620 The hosting API is up to date.
16:57:15 0620 Calling GetInterface method for the CorRuntimeHost interface.
16:57:15 0620 Success.
16:57:15 0620 Starting CLR...
16:57:15 0620 Success.
16:57:15 0620 Getting the CLR version.
16:57:15 0620 The CLR v4.0.30319 has been initialized successfully.
16:57:15 0620 Creating a new domain setup.
16:57:15 0620 Success.
16:57:15 0620 Getting the add-in directory.
16:57:15 0620 Success. The directory is 'C:\Program Files (x86)\BPS-ONE\BPS2Excel\'
16:57:15 0620 The 'shadow copy' is disabled.
16:57:15 0620 Creating a new application domain.
16:57:15 0620 Success.
16:57:15 0620 Getting the base directory for the domain.
16:57:15 0620 Success. The directory is 'C:\Program Files (x86)\BPS-ONE\BPS2Excel\'.
16:57:15 0620 Searching for the Add-in Express core library.
16:57:15 0620 Success. The 'AddinExpress.MSO.2005.dll' file is found.
16:57:15 0620 Creating an instance of the 'AddinExpress.Deployment.ADXRegistrator' class.
16:57:15 0620 Assembly identity is 'AddinExpress.MSO.2005'.
16:57:15 0620 Success.
16:57:15 0620 Unwrapping the instance of the 'AddinExpress.Deployment.ADXRegistrator' class.
16:57:15 0620 Success.
16:57:15 0620 Calling the managed registration procedure.
16:57:16 0620 Success.
16:57:16 0620 The add-in registration process is completed with HRESULT = 0.

Andrei Smolin

Add-in Express team

Posts: 18821
Joined: 2006-05-11

Hello Mirko,

Your COM add-in is per-machine but an Excel add-in is strictly per-user. Accordingly, running adxregistrator.exe by system (Process Owner: System) ends with registering the Excel add-in for the user System. You should let every user run adxregistrator.exe to register the XLL add-in for that user. Say, you can install your add-in per user.

A side note. Make sure your setup project deploys adxloader.dll, adxloader64.dll, adxregistrator.exe belonging to the Add-in Express version that you use on your development machine.

Andrei Smolin
Add-in Express Team Leader

Mirko Neubert

Posts: 85
Joined: 2007-09-24

Hi Andrei,
now we execute a .bat-File with folowing content

"C:\Program Files (x86)\BPS-ONE\BPS2Excel\adxregistrator.exe" /Install="BPS_Functions.dll" /privileges=user
pause

the Project is a .NetFramework 2 Project for x86
we dont have an adxloader64.BPS_Functions.dll - do we need it? How can we create it?

with the adxregistrator.log

Add-in Express Registrator Log File: 10/10/2017 11:25:56

Installation directory: C:\Program Files (x86)\BPS-ONE\BPS2Excel\
Registrator version: 6.7.3062.0
Operating System: Microsoft Professional (build 9200), 64-bit
Process Owner: Administrator
Command Line: "C:\Program Files (x86)\BPS-ONE\BPS2Excel\adxregistrator.exe" /Install="BPS_Functions.dll" /privileges=user
Run 'As Administrator': No
Process Elevated: No
Integrity Level: Medium
UAC (User Account Control): On
--------------------------------------------------------------
11:25:56 0616 Starting the add-in registration process.
11:25:56 0616 Loading mscoree.dll
11:25:56 0616 Success.
11:25:56 0616 .NET Framework installation directory:
11:25:56 0616 The latest version of .NET Framework: 'v4.0.30319'
11:25:56 0616 Loading CLR: v4.0.30319.
11:25:56 0616 Calling CLRCreateInstance method.
11:25:56 0616 Success.
11:25:56 0616 Calling GetRuntime method.
11:25:56 0616 Success.
11:25:56 0616 Checking if the hosting API of .NET Framework v4.0 beta is installed.
11:25:56 0616 The hosting API is up to date.
11:25:56 0616 Calling GetInterface method for the CorRuntimeHost interface.
11:25:56 0616 Success.
11:25:56 0616 Starting CLR...
11:25:56 0616 Success.
11:25:56 0616 Getting the CLR version.
11:25:56 0616 The CLR v4.0.30319 has been initialized successfully.
11:25:56 0616 Creating a new domain setup.
11:25:56 0616 Success.
11:25:56 0616 Getting the add-in directory.
11:25:56 0616 Success. The directory is 'C:\Program Files (x86)\BPS-ONE\BPS2Excel\'
11:25:56 0616 The 'shadow copy' is disabled.
11:25:56 0616 Creating a new application domain.
11:25:56 0616 Success.
11:25:56 0616 Getting the base directory for the domain.
11:25:56 0616 Success. The directory is 'C:\Program Files (x86)\BPS-ONE\BPS2Excel\'.
11:25:56 0616 Searching for the Add-in Express core library.
11:25:56 0616 Success. The 'AddinExpress.MSO.2005.dll' file is found.
11:25:56 0616 Creating an instance of the 'AddinExpress.Deployment.ADXRegistrator' class.
11:25:56 0616 Assembly identity is 'AddinExpress.MSO.2005'.
11:25:56 0616 Success.
11:25:56 0616 Unwrapping the instance of the 'AddinExpress.Deployment.ADXRegistrator' class.
11:25:56 0616 Success.
11:25:56 0616 Calling the managed registration procedure.
11:25:56 1096 The '/R "C:\Program Files (x86)\BPS-ONE\BPS2Excel\adxloader.BPS_Functions.dll"' registry value was created successfully for the 'BPS_Functions.BPSFunctions' class.
11:25:56 0616 Success.
11:25:56 0616 The add-in registration process is completed with HRESULT = 0.

and adxloader.log

Add-in Express Loader Log File: 10/10/2017 11:20:03

Startup directory: C:\Program Files (x86)\BPS-ONE\BPS2Excel\
Loader version: 6.7.3062.0
Operating System: Microsoft Professional (build 9200), 64-bit
Process Owner: Administrator
Command Line: "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE"
Run 'As Administrator': No
Process Elevated: No
Integrity Level: Medium
UAC (User Account Control): On
------------------------------------------------------------------------
11:20:03 1596 6544 Start.
11:20:03 1596 6544 Reading the registry key 'HKEY_CLASSES_ROOT\CLSID\{DA188FA0-E5E2-4AB7-A647-2FFBA676B6DF}'
11:20:03 1596 6544 Success. The registry key 'HKEY_CLASSES_ROOT\CLSID\{DA188FA0-E5E2-4AB7-A647-2FFBA676B6DF}' is closed.
11:20:03 1596 6544 Converting the '{4BA250A6-8BCA-46A6-982A-F340081187C3}' CLSID from string.
11:20:03 1596 6544 Success.
11:20:03 1596 6544 Attempting to get the class object by the '{4BA250A6-8BCA-46A6-982A-F340081187C3}' CLSID.
11:20:03 1596 6544 Success.
11:20:03 1596 6544 Creating a new instance of the add-in loader.
11:20:03 1596 6544 Loading mscoree.dll
11:20:03 1596 6544 Success.
11:20:03 1596 6544 Loading the configuration from the system registry.
11:20:03 1596 6544 Getting the latest CLR version.
11:20:03 1596 6544 The latest CLR version is 'v4.0.30319'.
11:20:03 1596 6544 The configuration has been loaded successfully.
11:20:03 1596 6544 Runtime version: v2.0.50727.
11:20:03 1596 6544 Assembly name: BPS2Excel, PublicKeyToken=F78C733F69BF0CBF.
11:20:03 1596 6544 Class name: Denzhorn.BPS2Excel.BPS2Excel.
11:20:03 1596 6544 Registry key: CLSID\{DA188FA0-E5E2-4AB7-A647-2FFBA676B6DF}.
11:20:03 1596 6544 Attempting to create a new instance of the managed add-in class: CLR - v2.0.50727
11:20:03 1596 6544 Loading CLR: v2.0.50727.
11:20:03 1596 6544 Calling CLRCreateInstance method.
11:20:03 1596 6544 Success.
11:20:03 1596 6544 Calling GetRuntime method.
11:20:03 1596 6544 Success.
11:20:03 1596 6544 Checking if the hosting API of .NET Framework v4.0 beta is installed.
11:20:03 1596 6544 The hosting API is up to date.
11:20:03 1596 6544 Calling GetInterface method for the CorRuntimeHost interface.
11:20:03 1596 6544 Success.
11:20:03 1596 6544 Starting CLR...
11:20:03 1596 6544 Success.
11:20:03 1596 6544 Getting the CLR version.
11:20:03 1596 6544 The CLR v2.0.50727 has been initialized successfully.
11:20:03 1596 6544 Creating a new domain setup.
11:20:03 1596 6544 Success.
11:20:03 1596 6544 Getting the add-in directory.
11:20:03 1596 6544 Success. The directory is 'C:\Program Files (x86)\BPS-ONE\BPS2Excel\'
11:20:03 1596 6544 The 'shadow copy' is enabled.
11:20:03 1596 6544 Creating a new application domain.
11:20:03 1596 6544 Success.
11:20:03 1596 6544 Unwrapping the managed class.
11:20:03 1596 6544 Success.
11:20:03 1596 6544 Querying the add-in extensibility.
11:20:03 1596 6544 Querying the custom task panes.
11:20:03 1596 6544 Querying the ribbon extensibility.
11:20:03 1596 6544 Success.
11:20:03 1596 6544 Querying the form regions.
11:20:03 1596 6544 Success.
11:20:03 1596 6544 Getting the dispid of the 'Dispose' method.
11:20:03 1596 6544 Success.
11:20:03 1596 6544 The managed add-in class has been created successfully.

Andrei Smolin

Add-in Express team

Posts: 18821
Joined: 2006-05-11

Hello Mirko,

The logs look okay for me.

Do you have several Excel versions on that machine?

Mirko Neubert writes:
11:25:56 1096 The '/R "C:\Program Files (x86)\BPS-ONE\BPS2Excel\adxloader.BPS_Functions.dll"' registry value was created successfully for the 'BPS_Functions.BPSFunctions' class.

Please check if the corresponding value exists in HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options. Does the Add-ins dialog in Excel shows your add-in? Is it enabled or not? What is its name in the dialog?

Andrei Smolin
Add-in Express Team Leader

Mirko Neubert

Posts: 85
Joined: 2007-09-24

Hello Andrei,
on this machine is only one Office Version (Office 2010)

Open:/R "C:\Program Files (x86)\BPS-ONE\BPS2Excel\adxloader.BPS_Functions.dll"

Screenshot:
[img]https://daten.denzhorn.de/kunden/index.php/s/0bmQOGoVkuAIAEl[/img]

Does the Add-ins dialog in Excel shows your add-in?

yes

Screenshot:
[img]https://daten.denzhorn.de/kunden/index.php/s/tF2r6tp5HrE0uXO[/img]

Is it enabled or not?

yes

What is its name in the dialog?

adxloader.BPS_Functions.dll
Screenshot:
[img]https://daten.denzhorn.de/kunden/index.php/s/zZtMWcUWcqOCBJn[/img]

Andrei Smolin

Add-in Express team

Posts: 18821
Joined: 2006-05-11

Hello Mirko,

Since the Excel add-in is a per-user thing and the COM add-in is per machine, they cannot be located in the same assembly.

Since the COM add-in and Excel add-in inhabit different assemblies, you should install them to different folders.

The can be installed to the same folder if they are located in the same assembly. This means they should be per user. In this case you won't be able to install them to Program Files - as this requires administrative permissions (by default).

Andrei Smolin
Add-in Express Team Leader

Mirko Neubert

Posts: 85
Joined: 2007-09-24

Hello Andrei,
i tried to load the Excel Add-in from another directory.
With the same resultat, it doesn't work

Command Line: "C:\BPS-ONE\BPS2Excel\adxregistrator.exe" /Install="BPS_Functions.dll" /privileges=user

the Com-Add-in is not changed and works, it is installed at C:\Program Files (x86)\BPS-ONE\BPS2Excel\

What could the reason be that the assembly is not found

Regards
Mirko

Regedit Screenshot
[img]https://daten.denzhorn.de/kunden/index.php/s/O1IXEppRm0X7UuC[/img]

Add-ins Screenshot
[img]https://daten.denzhorn.de/kunden/index.php/s/rwZuBtsToOOulGr[/img]

Com-Add-in Screenshot
[img]https://daten.denzhorn.de/kunden/index.php/s/LZBJJfAVdsrHuz9[/img]

Excel-Add-in Screenshot
[img]https://daten.denzhorn.de/kunden/index.php/s/ISCEmFlg92MaFWg[/img]

Dmitry Kostochko

Add-in Express team

Posts: 2875
Joined: 2004-04-05

Hi Mirko,

May it be that Excel starts via OLE Automation on that machine, for example:
instance = new Excel.Application();
instance.Visible = true;

Does your add-in start working if you re-enable it in the Add-ins dialog?

Also, I have noticed from the log files contents that you use outdated Add-in Express version 6.7. I would recommend that you upgrade to the latest version.

Mirko Neubert

Posts: 85
Joined: 2007-09-24

Hi Andrei,
Hi Dmitry,

Excel do not starts via OLE Automation
We disabled and enabled the Add-in in the Add-ins dialog, but it didn't work.

We did the following things:
We buildet a new Version of the Add-ins with the newest Loader 8.7 und with the .Net Framework 4 instead of 2.0

On our Hyper-V Test machine it works, to load the Com-Add-in and also the Excel-Add-In from the same directory

Hyper-V adxregistrator.log
[img]https://daten.denzhorn.de/kunden/index.php/s/3UTDdKaLKVHXtYQ[/img]

Hyper-V adxloader.log
[img]https://daten.denzhorn.de/kunden/index.php/s/k3duPuQbcP4pbfw[/img]

Hyper-V Excel Add-In-dialog
[img]https://daten.denzhorn.de/kunden/index.php/s/rDlgqSxt7QTscEz[/img]

On the customers machine the Com-Add-in works. The Excel-Add-in is registered same like on the Hyper-V,
but the Adxloader.log files are completly different

customers adxregistrator.log
[img]https://daten.denzhorn.de/kunden/index.php/s/MPrCvPnHtPFqqJY[/img]

customers adxloader.log
[img]https://daten.denzhorn.de/kunden/index.php/s/2SAs5sfmxcXcmIZ[/img]

customers Excel Add-In-dialog
[img]https://daten.denzhorn.de/kunden/index.php/s/ISCEmFlg92MaFWg[/img]

Next we tryed to Install the Excel-Add-in in a seperate directory, with the same resultat --> the Excel-Add-in don't work.

customers separate XLL adxregistrator.log
[img]https://daten.denzhorn.de/kunden/index.php/s/RsjzrflZqb4Q9L6[/img]

customers separate XLL adxloader.log
[img]https://daten.denzhorn.de/kunden/index.php/s/4kXThmQ8ISfYOF7[/img]

Why don't excel find the assembly?

Regards
Mirko

Sergey Grischenko

Add-in Express team

Posts: 7233
Joined: 2004-07-05

Hi Mirko,

Please try to create a new simple XLL add-in (without COM Add-in) and install it on the problematic PC via Add-in Express based setup project. Please let me know if it works.