EikonDDA = New EikonDesktopDataAPI [object does not support this property or method]

DDALY

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

Alex Putkov.1

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

DDALY

Hi @Alex Putkov.

Understood. The Excel COM add-in worked well - thank you!