Setting up VBA in Thomson Reuters Eikon

pierre-jean.campigotto

I have setup Reuters for VBA according as specified in PDF document:

- Added PVLbaApis

- Added references to:

* AdfinX Analytics Function

* AdfinX Analytics Object

* Real Time Library

* Dex2 Type Library

When I try to run:

Dim res As Boolean

Dim SrcList As AdfinXRtLib.AdxRtSourceList

Set SrcList = createAdxRtSourceList

I get a compile error "User-define type not defined" indicating that the type PASSLib.PassMgr is not defined.

Find more posts tagged with

eikon

vba

eikon-com-api

Accepted answers

Neil Shah

PASSLib.PassMgr is not a type that's used by Thomson Reuters Eikon Excel add in. I would download the samples from the documentation portal here and test it with them.

Edit: PASSLib.PassMgr was used historically in the PLVbaApis.bas file but its not any more. You can delete the whole CreatePassMgr() function. Or download the latest sample which no longer uses it

All comments

Neil Shah

PASSLib.PassMgr is not a type that's used by Thomson Reuters Eikon Excel add in. I would download the samples from the documentation portal here and test it with them.

Edit: PASSLib.PassMgr was used historically in the PLVbaApis.bas file but its not any more. You can delete the whole CreatePassMgr() function. Or download the latest sample which no longer uses it

pierre-jean.campigotto

Hi Neil,

Thank you for your help. I have now imported the add-in from one samples from the documentation portal. It works correctly.

As you mentioned PASSLib.PassMgr is not used anymore. Do you happen to know why my (up yo date) Eikon install does not have the newest version of the .bas file?

EXPLORE OUR SITES