EikonRefresh in VBA (LSEG Workspace)

michail.paraskevopoulos
michail.paraskevopoulos
in Eikon COM

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

Tagged:

Best Answer

  • Jirapongse
    Jirapongse
    Answer ✓

    @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

Answers

  • michail.paraskevopoulos
    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.

Categories