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