| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
query tables
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
query tables
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Query - Joining two tables.... | Excel Discussion (Misc queries) | |||
| Web Query from multiple tables | Excel Discussion (Misc queries) | |||
| Two Excel tables in MS Query | Excel Discussion (Misc queries) | |||
| Refreshing Query Tables | Excel Programming | |||
| Query Tables | Excel Programming | |||
Linear Mode
