xlautomationaddin with Excel 365 (64Bit)

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

xlautomationaddin with Excel 365 (64Bit)
 
Thomas Horstmann




Posts: 12
 Joined: 2020-08-24
I try to run the Delphi "xlautomationaddin" sample with Windows 10 (2004) and Office/Excel 365 (64Bit). I compiled the DLL for 64Bit. But I am not able to register the DLL (regsvr32 WksFunction.dll). It stops with error code 0x80004005.
Posted 24 Aug, 2020 06:26:07 Top
Andrei Smolin


Add-in Express team


Posts: 19138
 Joined: 2006-05-11
Hello Thomas,

That HResult relates to permissions. I don't have that example, could you please point me to it? Can it be that the example implements a per-machine COM add-in? If so, the issue may relate to the fact that an Excel add-in is a per-user entity.


Andrei Smolin
Add-in Express Team Leader
Posted 24 Aug, 2020 07:28:26 Top
Thomas Horstmann




Posts: 12
 Joined: 2020-08-24
Here is the original link:
https://www.add-in-express.com/files/howtos/d5-7/xlautomationaddin.zip
Posted 24 Aug, 2020 07:53:46 Top
Thomas Horstmann




Posts: 12
 Joined: 2020-08-24
It seems you are right. When I run "regsvr32" as administrator, it works.
Posted 24 Aug, 2020 08:09:19 Top
Andrei Smolin


Add-in Express team


Posts: 19138
 Joined: 2006-05-11
Hello Thomas,

That project is a per-machine COM add-in. To be an Excel add-in it must be per-user. Check section Registering with User Privileges; see the PDF file in the folder {Add-in Express}\Docs on your development PC.

And yes, you should start Delphi via Run as administrator.


Andrei Smolin
Add-in Express Team Leader
Posted 24 Aug, 2020 08:49:58 Top