EikonDDA = New EikonDesktopDataAPI [object does not support this property or method]
Hi Folks, Trying to use the Eikon Desktop AP in VBA for the first time using the sample code. I get [object does not support this property or method] on the first line. Any ideas? Thanks, Dermot
Hi @DDALY
You should not use EikonDesktopDataAPI library in Excel. This library is for use in custom applications. It allows a custom application to establish connectivity with Eikon, so that other COM libraries that provide data retrieval capabilities could retrieve data from Eikon. In Excel connectivity to Eikon platform is managed through Thomson Reuters Eikon Excel COM add-in. This is the same add-in that creates Thomson Reuters tab in Excel ribbon. For information on how to use Eikon COM APIs in MS Office see Quick Start guide and tutorials under "COM APIs for use in Microsoft Office":
https://developers.thomsonreuters.com/eikon-apis/com-apis-use-microsoft-office/quick-start
and
https://developers.thomsonreuters.com/eikon-apis/com-apis-use-microsoft-office/learning
Hi @Alex Putkov.
Understood. The Excel COM add-in worked well - thank you!