query tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I placed some 15 query tables in one sheet and i want to update all the query
tables.
For that the following command is useful to update one query table. To
update all
I have to repeat the command for 15 times. Is there any single line command
(except "refresh all") that updates all web queries?

ActiveSheet.QueryTables(1).Refresh BackgroundQuery:=False
 
Ezil,

Here's one way:

Dim qry As QueryTable

For Each qry In ActiveSheet.QueryTables
qry.Refresh BackgroundQuery:=False
Next qry
 
Back
Top