Thanks. I'm not understanding the suggestion by Zvoni. I've tried setting a change event on the 'Web Data' sheet. I've also first cleared the Web Data sheet and then checked to see of any rows were populated with the query before continuing with code, but these don't work either. I have found something, though, that appears to work and it's quite simple. I've change the query to disallow background (asynch) refresh. With this, the next line of code after my ActiveWorkbook.RefreshAll does not execute until the 'Web Data' page is fully refreshed. I appreciate all the suggestions, though.

Before I close this, I have used a 'Shell and Wait' routine before to make sure processing was done in a single thread mode. What would my DoCmd look like if I were to use 'Shell and Wait'? By the way, if I loop through all the worksheets, my query table count is always zero. Why is that?