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.
Bookmarks