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