VBA Code to refresh Query Table

[thelostscott]

Hi all,

I have written some code that when a button is selected will Refresh a Data Query Table and all of it's information. However, I seem to be getting issues, can some one point me in the right direction with the code?

.Sheets("Sheet 1").ListObject.QueryTable.Refresh BackgroundQuery:=False

When I recorded myslef doing this process it looked like this:

Sheets("Sheet 1").Select
Range("D70872").Select
Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False

Many thanks!

 

[Andrew Poulsom]

Maybe try:

.Sheets("Sheet 1").Range("D70872").ListObject.QueryTable.Refresh BackgroundQuery:=False

 

[thelostscott]

That seemed to do it.... With a Pivot Table refresh you can just add the PivotTable Name to the code and it will Refresh from there but not the same with a Table?

Thanks!