How can I stop or resume the updates in Eikon Excel via vba ?

How can I stop or resume the updates in Eikon Excel via vba ?

Best Answer

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭
    Answer ✓

    The documentation describing the use of Eikon COM APIs in Microsoft Office is available under the namesake section on this portal.
    https://developers.refinitiv.com/eikon-apis/com-apis-use-microsoft-office
    The Developer Guide is available under the Documentation tab and a set of tutorials is available under Tutorials. There's a specific tutorial on contributions. Programmatic contributions using Eikon COM APIs are only available through TREP infrastructure. Direct contributions over the Internet, which are possible using =RtContribute function in Excel, are currently not available through any Eikon APIs.

Answers

  • Alex Putkov.1
    Alex Putkov.1 ✭✭✭✭✭

    You can use the following command to toggle pause/resume updates

    Application.Run "PLPauseResumeEventHandler"
    To learn how to monitor the updates status see this tutorial.
  • Thanks very much for the answer. Is there any document, where I can find all the commands ? For example to contribute via vba.....

  • Hi Alex, thank you, your answer was very helpful