Results 1 to 1 of 1
2013-10-15, 11:16 #1
- Join Date
- Jun 2001
- New York, New York, Lebanon
- Thanked 1 Time in 1 Post
Web Query to get all result pages
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?
Wassim<img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>