Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AUTO_OPEN and Automatic Data Refresh
We have a workbook with queries bound to a few of the sheets. Once the
queries have automatically refreshed, I'd like a macro to run. AUTO_OPEN macros appear to run before the data is refreshed. Any thoughts on how to accomplish this? I thought I might have the AUTO_OPEN macro check to see if the queries were done and remain in a wait loop until the queries finished but I can't find the dbengine in the object model and I'm not sure if it supports a "busy" status, anyway. I thought I might just probe a known cell to see if the queries were complete but that seems like an awfully awkward way to do this. So, I'm looking for ideas. Any suggestions would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic refresh of external data | Excel Worksheet Functions | |||
Automatic refresh of external data | Excel Discussion (Misc queries) | |||
Automatic refresh of external data | Links and Linking in Excel | |||
Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
automatic refresh of formula that seeks data from an add-in | Excel Programming |