Installation Failures of XLL Addin

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

Installation Failures of XLL Addin
 
Sean Devenish




Posts: 75
Joined: 2015-11-30
Hi,

We are experiencing intermittent but frequent issues when we release a new version of our COM and Excel add-ins. We have an auto-update process that takes place starting with a check when you open Excel - this will then download and run a .exe installer silently in the background.

This has worked without problem for many years. However, recently, we have had some intermittent results where sometimes all installs fine, and others where the COM add-in is successfully installed and registered, but the XLL add-in is not updated and remains the old version. Sometimes the update happens correctly for the same user but the subsequent update fails to update the XLL addin.

We are looking for any advice or any ideas as to why this might be happening. It doesn’t appear to be tied in with any particular Office version, reports across 2013 to 2019.

This is what the InnoSetup looks like, you can see it just calls the install parameter on the adxregistrator:

Filename: "{app}\adxregistrator.exe"; Parameters: "/install=""Workpapers.Next.Addin.dll"" /privileges={code:InstallPrivileges} /logFileLocation=""{app}"""; Description: "Register the addin with Excel"

This is what the Manifest file looks like:

<?xml version="1.0" encoding="utf-8"?> <configuration> <assemblyIdentity name="Workpapers.Next.Addin" xllClass="Workpapers.Next.XLLModule" imageRuntimeVersion="v4.0.30319" /> <loaderSettings generateLogFile="true" shadowCopyEnabled="false" privileges="user" configFileName="Workpapers.Next.Addin.dll.config" /> </configuration>

Any assistance is greatly appreciated.
Posted 30 Apr, 2020 00:14:05 Top
Andrei Smolin


Add-in Express team


Posts: 17438
Joined: 2006-05-11
Hello Sean,

Sean Devenish writes:
/privileges={code:InstallPrivileges}


XLL requires this to be "user"; any other value would be incorrect.

Could this be the cause of the issue?

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 30 Apr, 2020 04:32:50 Top
Sean Devenish




Posts: 75
Joined: 2015-11-30
Hi Andrei,

For the automated installation, this piece of code is subbed out with the word 'user' by our innosetup script - (in other installs it is subbed out with 'admin' but those are currently working).

We find the issue only occurs during the automated install, which happens silently in the background while Excel is running. It is interesting that our install process has not changed in years but this has only recently occurred in the last few months.

For affected users, we can run the same install.exe directly (manually) over the top of their existing installation and everything installs correctly and works as expected. It is only this automated silent install that is run by script while Excel is running.
Posted 04 May, 2020 20:26:56 Top
Andrei Smolin


Add-in Express team


Posts: 17438
Joined: 2006-05-11
Hello Sean,

Could you please provide adxregistrator.log created for such a user by this automated silent install and by install.exe started directly?

Can it be that Excel is started programmatically at any moment? By your script? By something else before you start the script?

Sean Devenish writes:
For affected users, we can run the same install.exe directly (manually) over the top of their existing installation and everything installs correctly and works as expected.


Do you do this while Excel is running? What value do you have in the DisplayAlerts property of the add-in module?

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 05 May, 2020 01:25:18 Top
Sean Devenish




Posts: 75
Joined: 2015-11-30
Hi Andrei,

will do, can you supply us a suitable email address that we can forward the logs to you?

And yes, the silent install occurs while Excel is running, and DisplayAlerts is set to true in the add-in module.
Posted 06 May, 2020 02:42:31 Top
Andrei Smolin


Add-in Express team


Posts: 17438
Joined: 2006-05-11
Hello Sean,

You can send it to the support email address; find it in {Add-in Express installation folder}\readme.txt. Please make sure your email contains a link to this topic.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 06 May, 2020 02:50:43 Top