Hi
I am downloading options information for different time periods, so that means I have 12 distinct webqueries.

Here is an example of my code
ThisWorkbook.Sheets("Aug07").QueryTables("Aug07").Connection = "URL;http://finance.yahoo.com/q/op?s=XXXXXXX

ThisWorkbook.Sheets("Aug07").QueryTables("Aug07").Refresh
BackgroundQuery = False

Eventhough I have the backgroundquery=false, there is still a time lag between the time all the sheets are refreshed(data comes in) and the next part of the code executes.

What should I do? Any help with be much appreciated
thanks in advance