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

Question

question

William.hendrickson

3 ●0 ●1 ●1

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

eikon api eikon-com-api

Mar 01, 2017 at 12:14 PM

10 |1500

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

William.hendrickson Mar 01, 2017 at 03:49 PM

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 William.hendrickson Mar 01, 2017 at 04:04 PM

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

Jirapongse Mar 16, 2017 at 01:05 AM

Thank you for your participation in the forum.

Are any of the replies below satisfactory in resolving your query?

If yes please click the 'Accept' text next to the most appropriate reply. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

Answer 1 · 2017-03-01T14:09:11Z

Alex Putkov.1

39.4k ●77 ●11 ●27

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:

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

Best regards,

Alex

Mar 01, 2017 at 02:09 PM

10 |1500

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