question

Upvotes
Accepted
3 0 0 1

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

eikoneikon-com-api
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
Accepted
39.2k 75 11 27

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.

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
39.2k 75 11 27

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.
icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
3 0 0 1

Thanks very much for the answer. Is there any document, where I can find all the commands ? For example to contribute via vba.....

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Upvotes
3 0 0 1

Hi Alex, thank you, your answer was very helpful

icon clock
10 |1500

Up to 2 attachments (including images) can be used with a maximum of 5.0 MiB each and 10.0 MiB total.

Click below to post an Idea Post Idea