Check Status of EIKON Plugin

golebiewski.dawid · March 2021

Hi - have dig through the web but did not find an satisfactory answer. I have a macro-enabled eikon template which calls a few of other procedures I do have in modules. I need to make sure EIKON is connected in EXCEL before calling these procedures otherwise the tool gets stucked and freezes. Is there a simple way to check the EIKON status and prompt e.g. a msgBox reminding the user to please connect? Found a few posts but they just do not work.

Alex Putkov.1 · March 2021

@golebiewski.dawid

Please see the tutorial for Eikon Excel Synchronization Manager COM library, which provides information about the current state of Eikon Excel add-in, including the connection state.

Before using Eikon Excel Synchronization Manager library it is advisory to check whether Eikon Excel COM add-in is loaded into the session of Excel, which is a prerequisite for using any Eikon COM APIs in Excel. For an example of how to check if Eikon Excel COM add-in is loaded into Excel session see this thread.

golebiewski.dawid · March 2021

https://community.developers.refinitiv.com/discussion/comment/75451#Comment_75451

Thanks for the kind response I do get a error following the link provided:

Resource at '/content/devportal/en_us/401.html' not found: No resource found

Alex Putkov.1 · March 2021

https://community.developers.refinitiv.com/discussion/comment/75452#Comment_75452

The link is correct. The problem is likely with your browser. Try another browser or try clearing cookies (or use incognito mode). Here's the link to a post from another user who experienced similar issue and was able to resolve it.

golebiewski.dawid · March 2021

https://community.developers.refinitiv.com/discussion/comment/75449#Comment_75449

This is helpful. Thank you! It means, when i add this to my project / workbook referencing the PLSynchronizationMgrLib.SynchronizationMgr, anyone else who will open the file will automatically have this functions loaded in his excel. Meaning, when distributing my tool/template there is no need for others to instal/reference the syncronisation libary manually (?)

IGNORE: I get the error message "Error in loading DLL" (SORTED: Had to close the sample file before loading the DLL into my own project)

golebiewski.dawid · March 2021

https://community.developers.refinitiv.com/discussion/comment/75450#Comment_75450

Sorry - not yet sorted, so when adding PVVBAAPIS.dll i get the message "Can't add reference to the specified file"

Alex Putkov.1 · March 2021

https://community.developers.refinitiv.com/discussion/comment/75461#Comment_75461

You are correct, you can create an instance of PLSynchronizationMgrLib.SynchronizationMgr class as long as Excel session has Eikon Excel add-in loaded, which is why in my previous post I suggested running the check for the load status of Eikon Excel COM add-in.

PLVbaApis.dll is not a COM DLL, you can't add a reference to it from a VBA project. Instead you need to declare CreateReutersObject function provided by this DLL using

Private Declare Function CreateReutersObject Lib "PLVbaApis.dll" (ByVal progID As String) As Object

You can find an example of this declaration in PLVbaApis.bas module referenced in the tutorial.

Check Status of EIKON Plugin

Best Answer

Answers

Resource at '/content/devportal/en_us/401.html' not found: No resource found

Categories

EXPLORE OUR SITES

Check Status of EIKON Plugin

Best Answer

Answers

Resource at '/content/devportal/en_us/401.html' not found: No resource found

Categories