I'm using Excel 2002 SP3...

I wrote a macro over a year ago that performs several web queries and
copies/pastes data between each new query. Last year, after writing the
macro, the program would nicely zip through all of the queries and everything
would be great. The last time I ran the macro successfully was in October
2004.

In April 2005, I ran the macro again. The URLs in question are still exactly
the same. The problem now is the run-time error '1004', "unable to open" the
URL. If I hit "Debug", then run it again to continue, it might successfully
refresh that web query and move on. It's hit or miss.

My theory is that the web query refresh method is not being patient enough
for data. I can immediately open up an IE window and load the same pages
easily. I'm wondering if the refresh method is not waiting long enough for
the data to load. Is there a way to set a parameter to tell it to wait longer
for the URL to open?

Alternately, I've attempted to write an error-handling mechanism, but the
best I can do is to get it to refresh one extra time. After that, it just
crashes. I know I'm flirting with an infinite loop, but it would be nice to
get the query to keep trying until it finds the data. I know it's out there!

Any feedback would be greatly appreciated.

Thanks,
Hfly