Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing Query Tables
Suspect this is in a sheet module in which case, the unqualified references
will remain pointed at the sheet containing the module rather than the activesheet (which is your intent). The revision below should work if my assumption is correct. For Each ws In Worksheets ' ws.Activate For Each ws.query In QueryTables ws.query.Refresh BackgroundQuery:=False Next Next -- Regards, Tom Ogilvy "Simon Shaw" wrote in message ... I am trying to run a macro to refresh all query tables in my sheet. I am using the following code, but it does not seem to update the tables, but it doesn't error out either. any ideas? For Each ws In Worksheets ws.Activate For Each query In QueryTables query.Refresh BackgroundQuery:=False Next Next |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing Query Tables
"Tom Ogilvy" wrote in message ... Suspect this is in a sheet module in which case, the unqualified references will remain pointed at the sheet containing the module rather than the activesheet (which is your intent). The revision below should work if my assumption is correct. For Each ws In Worksheets ' ws.Activate For Each ws.query In QueryTables ws.query.Refresh BackgroundQuery:=False Next Next For Each query In ws.QueryTables query.Refresh False Next query ? -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refreshing Query Tables
Yep, went brain dead for a minute.
Thanks for the correction. -- Regards, Tom Ogilvy "Dick Kusleika" wrote in message ... "Tom Ogilvy" wrote in message ... Suspect this is in a sheet module in which case, the unqualified references will remain pointed at the sheet containing the module rather than the activesheet (which is your intent). The revision below should work if my assumption is correct. For Each ws In Worksheets ' ws.Activate For Each ws.query In QueryTables ws.query.Refresh BackgroundQuery:=False Next Next For Each query In ws.QueryTables query.Refresh False Next query ? -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refreshing an Excel Query | Excel Discussion (Misc queries) | |||
Refreshing Pivot Tables | Excel Discussion (Misc queries) | |||
Refreshing Pivot Tables | Excel Worksheet Functions | |||
Refreshing Query Tables | Excel Programming | |||
Refreshing Pivot Tables QUery | Excel Programming |