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

William.hendrickson

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

Alex Putkov.1

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.thomsonreuters.com/eikon-com/eikon-desktop-data-api

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

https://developers.thomsonreuters.com/eikon-com/eikon-desktop-data-api/learning?content=806&type=learning_material_item

Best regards,

Alex

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

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