Web refresh macro (2003 SP3)

[steveh]

Morning all

I have a workbook with quite a few web queries and for which I want to record a web refresh macro for. If I record the macro and right click on the first set of data and select refresh data will it refresh all of the web queries or only that one?

[HansV]

The recorded macro would act on one web query only - the one selected when you run the macro.

Here is a macro that will update all external data in a workbook:

Code: Select all

Sub UpdateAllWebqueries()
  Dim wsh As Worksheet
  Dim qtb As QueryTable
  Application.ScreenUpdating = False
  For Each wsh In ActiveWorkbook.Worksheets
    For Each qtb In wsh.QueryTables
      qtb.Refresh BackgroundQuery:=False
    Next qtb
  Next wsh
  Application.ScreenUpdating = True
End Sub

[steveh]

The recorded macro would act on one web query only - the one selected when you run the macro.

Here is a macro that will update all external data in a workbook:

Hi Hans

Fantastic as usual, the Christmas hamper is getting bigger and bigger!!