question

Upvotes
Accepted

EikonRefresh in VBA (LSEG Workspace)

We will shortly migrate from Refinitiv Eikon to LSEG Workspace and I would like to understand whether the EikonRefresh functions in VBA will continue to work or whether a different approach will be needed.

Thanks,

Michail

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.

Upvote
Accepted
79.2k 251 52 74

@michail.paraskevopoulos

Thank you for reaching out to us.

I checkd and found that you can use the following code in Workspace Excel.

Sub WSRefreshSelection()
    DoEvents
    Application.Run "WorkspaceRefreshSelection", True, 120000
    DoEvents
End Sub
Sub WSRefreshSheet()
    DoEvents
    Application.Run "WorkspaceRefreshWorksheet", True, 120000
    DoEvents
End Sub
Sub WSRefreshWorkbook()
    DoEvents
    Application.Run "WorkspaceRefreshWorkbook", True, 120000
    DoEvents
End Sub
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

That is the kind of answer I was actually hoping for. Thus, I just need to replace the respective references in my code with the new functions and it will run as usual. Many thanks for sorting this out.

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.