Thanks for your reply!

However, my colleague is trying to solve exactly the same problem an
here's what he found:

He's got 2 queries in the same spreadsheet plus VBA code working wit
the data from the queries. It is very clear that while the querie
haven't finished retrieving data, VBA is not waiting but executing al
the commands! So the code finishes but the data is still bein
retrieved, which defeats the purpose of the code.

There's an option to "disable background refresh" but this doesn't hel
either.

Isn't there some sort of "Pause before blah-blah" or "Wait for x
time" command? I couldn't find anything of the sort but maybe you know


Thanks

--
Message posted from http://www.ExcelForum.com