Hi Loungers

Is there a way to run a web query that can bring all resulting pages?

For example you go to a web site and run a query for events happening between two dates. The results come into multiple pages. Page one will have result 1 through 8, and at the bottom of the page you see a Next or something else to indicate that there are more results, so you click on Next and you go to page two where you will have result 9 to 16, click next and you go to page 3 and you get results 17 to 24 and so on.

When I ask Excel 2010 to get external data from web, it only gets the first page of results.

Could I change the URL somehow to tell the web query to get all pages?