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.
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.