| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide rows and update fileds in different sheets | Excel Discussion (Misc queries) | |||
| Macros for Protect/Unprotect all sheets in a workbook | Excel Discussion (Misc queries) | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| How do I make a sheet that combines all tabbed sheets & update as. | New Users to Excel | |||
Hybrid Mode
