| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
waiting for data refresh before continuing VBA sub
I want to open a workbook, update the data from Access
using MS Query, then saveas the workbook with a new name. Excel wants to run the sub without waiting for the refreshed data. Is there any way to get the VBA to recognise that the refresh has finished and then continue with sub? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating waiting times | Excel Worksheet Functions | |||
| Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
| Waiting for data to be returned from Microsoft Query | Excel Discussion (Misc queries) | |||
| Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming | |||
| waiting | Excel Programming | |||
Threaded Mode
