View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rich
 
Posts: n/a
Default 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