Adfinx Real Time returns nothing

suyee.tan
suyee.tan Newcomer
in Eikon COM

Hi, I want to retrieve historical time series and real time data using Excel VBA. I downloaded the "Complete Microsoft Office APIs Tutorial Samples". Adfinx Real Time functions such as AdxRtList, AdxRtHistory are not working. It is returning "Run time error 91: Object variable or With block variable not set". Other libraries within the sample are working fine (Dex2, Adfin Analytics & RHistory).

Tagged:

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    Hi,

    The issue must be specific to your machine, as we cannot reproduce it on our end. I would suggest you open a service case with Thomson Reuters Helpdesk.

Answers

  • Zhenya Kovalyov
    Zhenya Kovalyov LSEG

    Could you confirm which version of Excel you are using please?

  • matthew314
    matthew314 Newcomer

    Hi All

    I had this same problem until I did the following. Not sure exactly which thing fixed it.

    1. Uninstall Office and Eikon

    2. Install 32-bit version of Office - (I think this is the fix).

    3. Install Eikon

    4. Refence all dlls mentioned in PLAVbaApi.bas including rtx.dll, adxoo.dll, adxfo.dll, dex2.dll

    5. Make sure the Add-in "Eikon for Office" is installed and signed in.

    Now it works.

    Kind regards

    Matt

Categories