COM APIs in Office 64bits

mahjoub.faraj
mahjoub.faraj
in Eikon COM

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

Tagged:

Best Answer

  • Jirapongse
    Jirapongse
    Answer ✓

    @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.






Categories