I have a spreadsheet that is linked to an Access query. I am opening this
spreadsheet with a macro. In the macro, I am executing a refresh command and
then I need to do some other things with the macro (such as opening other
files and grabbing certain cells and putting them in a new spreadsheet). It
seems that sometimes the macro continues without the refresh having
completed. Is there a way to ensure the macro does not continue until the
refresh has finished?