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

Find more posts tagged with

vba

Accepted answers

Jirapongse

@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

All comments

Jirapongse

@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

michail.paraskevopoulos

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.

NICOLAS.BARUSSAUD

@Jirapongse Hello, could you please explain the meaning of the two arguments (True and 120000) passed to the refresh funtions ?

Jirapongse

@NICOLAS.BARUSSAUD

It should be similar to the EikonRefresh functions, as mentioned on this discussion.

EXPLORE OUR SITES