Query Table question

[chriss1519]

I have an excel file which has data linked to an external source. I want to program a macro to update this query. When I recorded a macro to do this, I get:

Selection.QueryTable.Refresh BackgroundQuery:=False

I don't want to use selection because the query output range will change with every update.

Thoughts?

 

[Norie]

Workbooks have a RefreshAll method which:

Refreshes all external data ranges and PivotTable reports in the specified workbook.

Perhaps that might work.

ActiveWorkbook.RefreshAll