ExcelBanter - Update all Sheets

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Update all Sheets (https://www.excelbanter.com/excel-discussion-misc-queries/88850-update-all-sheets.html)

Rich

Update all Sheets

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

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