question

Upvotes
Accepted
DDALY avatar image
191 ●2 ●7 ●14

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

eikoneikon-com-apivba
eikon.jpg (133.0 KiB)
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

· Write an Answer
Upvotes
Accepted
Alex Putkov.1 avatar image
39.4k ●77 ●11 ●27

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Upvotes
DDALY avatar image
191 ●2 ●7 ●14

Hi @Alex Putkov.

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

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.