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

William.hendrickson · March 2017

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

Alex Putkov.1 · March 2017

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

William.hendrickson · March 2017

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 · March 2017

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

Best Answer