Update all Sheets

R

Rich

I have 2 linked queries to My access database.
I have 4 Worksheets in my Excel file.

I created a new MAIN worksheet. I created a button that should update
my tabs with the 2 MS Access queries.

The below code is not working?

Set wks = ActiveSheet
For Each qryTab In wks.QueryTables
qryTab.Refresh
Next qryTab
 
Top