How to connect to Reuters Eikon Excel programmatically with VBA?

pierre-jean.campigotto

Hi there,

Let's say I have an excel session which is logged-out of Reuters Eikon (Offline in the ribbon). How do I connect to Reuters Eikon programmatically via vba? Basically an equivalent to pressing the button Offline in the Reuters ribbon to connect (in Settings).

I have tried unsuccessfully to look into the PLSynchronizationMgr library.

And side question: where do I find the user documentation for a specific library? (f.ex. PLSynchronizationMgr library)

Thank you.

Zhenya Kovalyov

@pierre-jean.campigotto

synchronizationmgrxlsm.zip

It is all possible with the PLSynchronizationMgrLib.SynchronizationMgr, I’m attaching the example that tracks the state of Eikon Excel Add-in and reacts on the event of Connect, Disconnect, Pause, Resume and Refresh.

Alternatively, you can find a tutorial here.

pierre-jean.campigotto

fantastic, thank you.

FWIW this tutorial is not part of the Complete Microsoft Office APIs Tutorial Samples. I only checked in there and hence did not notice that there was a tutorial dedicated to PLSynchronizationMgrLib.