question

Upvotes
Accepted
3 0 1 2

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 512.0 KiB each and 1.0 MiB total.

Hi @Juergen Burkart,

Thank you for your participation in the forum.

Is the reply below satisfactory in answering your question? If yes please click the 'Accept' text next to the most appropriate reply.

If you have already known an answer, please share your answer, and then accept it. This will guide all community members who have a similar question.

Otherwise please post again offering further insight into your question.

Thanks,

AHS

Upvotes
Accepted
39.4k 77 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 512.0 KiB each and 1.0 MiB total.

Upvotes
39.4k 77 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 512.0 KiB each and 1.0 MiB total.

Upvotes
3 0 1 2

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 512.0 KiB each and 1.0 MiB total.

Upvotes
3 0 1 2

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 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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