Q:

Refresh Only One Worksheet of Bloomberg Data With VBA

I need to refresh only one worksheet of Bloomberg data with VBA.
If I try with:
Application.Run "RefreshAllWorkbooks"
Application.Run "RefreshAllStaticData"

it will refresh all the Workbook.
Do you know how to refresh only one worksheet?
Thanks.

A:

If you have a few query tables in a give worksheet, the easiest way to refresh each of them is to create a for-loop. This would refresh all the objects in the first worksheet of Excel:
Sub TestMe()

    Dim jLo As ListObject
    For Each jLo In Worksheets(1).ListObjects
        jLo.QueryTable.Refresh
    Next jLo

End Sub

