ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Code To Refresh Query Table (https://www.excelbanter.com/excel-discussion-misc-queries/121888-code-refresh-query-table.html)

Carl

Code To Refresh Query Table
 
I am trying to refresh data in a query table but the following code does not
work: "Selection.QueryTable.Refresh BackgroundQuery:=False". If I just
right-click on the cell containing the querry and select "Refresh data" from
the menu it works fine but this must be automated. Please advise if anyone
knows the correct code. Thanks in advance.


All times are GMT +1. The time now is 09:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com