Refreshing a Specific Worksheet on Workspace VBA

Alex.Conti
Alex.Conti LSEG
in Eikon COM

Having difficulty with using the Application.Run "WorkspaceRefreshWorksheet" VBA function on Workspace. I found the information below on refreshing worksheets:

2 - EikonRefreshWorksheet takes a third optional parameter worksheetToRefresh. This is the name of the worksheet to refresh. It can be in "[Book1]Sheet1" format to refresh a sheet in a workbook that isn't in the foreground. Or just "Sheet1" which will look for the sheet in the ActiveWorkbook.


But still getting an error when running the code below:

Dim curvesbook_USD As String

curvesbook_USD = ActiveWorkbook.Name

Call Application.Run("WorkspaceRefreshWorksheet", True, 10000, CStr("[" & curvesbook_USD & "]" & "ReutersUSD_hist"))


Does "WorkspaceRefreshWorksheet" allow for a third parameter to assign a worksheet name like on "EikonRefreshWorksheet"?


Thank you.

Tagged:

Best Answer

  • Jirapongse
    Jirapongse ✭✭✭✭✭
    Answer ✓

    @Alex.Conti

    Thank you for reaching out to us.

    I have done a quick test andn found that WorkspaceRefreshWorksheet supports the third parameter.

    Sub WSRefreshSheet()
        DoEvents
        Application.Run "WorkspaceRefreshWorksheet", True, 120000, "Sheet1"
        DoEvents
    End Sub

    However, please contact the Workspace Excel support team directly to confirm it.

Answers

Categories