question

Upvotes
Accepted
William.hendrickson avatar image
3 ●0 ●1 ●1

Set myRSrchMgr = CreateRSearchMgr() is creating Run-time error 13 "Type mismatch"

This works in excel vba editor but it is producing this error in VB 6.0 editor

eikoneikon-com-apiapi
icon clock
10 |1500

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

William.hendrickson avatar image William.hendrickson

Thanks Alex.

Worked exactly as expected. Any idea when the maximum rows limit of 2000 will be updated so you don't need to do multiple queries?

Alex Putkov.1 avatar image Alex Putkov.1 William.hendrickson

This is a rather unfortunate limitation, but I'm afraid I'm not aware of any immediate plans to address it.

1 Answer

Upvotes
Accepted
Alex Putkov.1 avatar image
39.2k ●75 ●11 ●27

Hi @William.hendrickson,

CreateRSearchMgr function is only supposed to work in Excel VBA.

To use Eikon COM APIs in custom applications, please see the relevant section on this portal:

https://developers.refinitiv.com/en/api-catalog/eikon/com-apis-for-use-in-custom-applications

Specifically for using RSearch COM library in custom applications see the following tutorial:

https://developers.refinitiv.com/en/api-catalog/eikon/com-apis-for-use-in-custom-applications/tutorials#tutorial-4-search

Best regards,

Alex

icon clock
10 |1500

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

Click below to post an Idea Post Idea