I query a web page multiple times in a loop with a parameter to get different
pages. QueryTable does not get all the info I like. Furthermore, it does
not work unless one put in a delay in order for excel to wait for the result.


Found the OPEN method in a book; Workbooks.Open("http:// .....
This method is more robust, does not need a delay. I use .Find to parse
the page to get the data.
Just in case, I added a loop delay of about 10 seconds to avoid "issues"
related to server loading. However, eventually got message in the opened
excel book which indicates that the server stopped me. Once I got 100 hits
without problem. Last time I got 7 when the special message showed up for
the first time. Have not tested to see whether the server allows me again or
not.

Does the Workbooks.Open method behave different than a regular browser
click, apparently. Is there a method where one can download the entire web
page without looking different than a regular web access (from the server's
perspective)? I do not mind to have a long loop delay, e.g. 1 minute or more.

regards
Alex