D
davidfox789
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
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