Excel Web query - I can only get max. 9 queries from my macro

[pfrattali]

I'm trying to create a macro that needs to get info from about 500 different web pages. After the 9th page it will not allow me to query it. I get error '1004' and the following message: 'Unable to open (website address). Cannot download the information requested.

Sometimes this happens after the 7th page. But mostly after the 9th.
I am using a Do Loop to query through the different pages.

If anyone can help thanks,