Setting up VBA in Thomson Reuters Eikon

pierre-jean.campigotto
pierre-jean.campigotto
in Eikon COM

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.

Tagged:

Best Answer

  • Neil Shah
    Neil Shah
    Answer ✓

    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


Answers

  • pierre-jean.campigotto
    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?

Categories