VBA to refresh data table

[maclachlan19]

I've been using a piece of code in earlier versions of Excel (currently using 2016) which has always worked fine. But I'm now having problems.

Worksheets("WO Status").Range("A2").QueryTable.Refresh BackgroundQuery:=False

I'm trying to build a button that will refresh a data table on another sheet. The data table is a database query to a SQL database.

I have named the datatable "WOStatus". It would be great if I could use the table name in my vba coding, instead of a cell range. But either way I'm just hoping to get it to work.

Thanks

 

[maclachlan19]

Think I figured this out.
Sheets("WO Status").ListObjects("WOdata").QueryTable.Refresh BackgroundQuery:=False