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).
1
●0 ●1 ●3
Adfinx Real Time returns nothing
Thank you for your participation in the forum.
Are any of the replies below satisfactory in resolving your query?
If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.
Otherwise please post again offering further insight into your question.
Thanks,
AHS
Please be informed that a reply has been verified as correct in answering the question, and has been marked as such. Thanks, AHS
39.4k
●77 ●11 ●27
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.
1
●0 ●0 ●0
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
