Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Which runs first, Workbook_Open() or external query refresh?
I want to process some data when the user opens a spreadsheet, but not
until an external Access query has been refreshed. "Refresh data on file open..." has been checked in the data range properties. But I think my Workbook_Open() code is running before auto refresh happens. Where is the best place to put code to ensure that it runs after the external MS-Query has been updated? As a last resort, I could have the user press a button after all data has been refreshed, but that is messy. Thanks in advance.... ...df |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
external data automatic refresh through macro/query | Excel Discussion (Misc queries) | |||
Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
Prompting to allow External Query Data Refresh | Excel Discussion (Misc queries) | |||
Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming |