ExcelBanter - query tables

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - query tables (https://www.excelbanter.com/excel-programming/394535-query-tables.html)

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

--
Hope that helps.

Vergel Adriano

"ezil" wrote:

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