VBA and external queries
There needs to be a call back function within VBA to establish when a query has finished running so that a macro can be paused until the data has been updated.
I've tried all ways I can find to do this via testing QueryTable.Refreshing property in a loop but none seems to work. Application.wait and any timer loop using GetTickCount() and DoEvents pauses the refresh as well. Unless I'm missing something.
But it is pretty critical ... I don't want to risk the post-processing of data until I am certain that it has all be updated.