question

Upvotes
Accepted
3 2 1 3

COM APIs in Office 64bits

Hello Team,

My configuration is:

Windows 10 64bits

Office 365 64bits


I tried running the ALL_COM_APIs.xlsm tutorials file and I performed the following fixes:

-Added PtrSafe keyword where missing

-Remapped the rtx.dll reference path


Tutorials 1 to 5 and 9keep failing with error "Runtime error '91' Object Variable or With block variable not set"

Tutorials 6 to 8 work properly


Is there a fix to get all tutorials work in my environment?

Thanks for your help

eikon-com-apivbamicrosoft-office-365
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Upvotes
Accepted
45.2k 103 43 60

@mahjoub.faraj

Those tutorials are for Excel 32bit.

I found that some Eikon COM objects are available for Excel 64bit, such as DEX2, RSearch, and RHistory. Typically, those DLLs are in the bin (x64) directory in Eikon.

I am unable to find the 64bit DLL of the AdfinX Real-Time Library (rtx.dll) which is required by tutorials 1 to 5.






icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.