Web Query from multiple varying length pages

[Guest]

I have a excel web query that I am working on and am running into this problem.
The website that I am pulling from has a list of items on a page (about 50).
It works great for the first page, but there are more on page 2, 3, 4, 5
etc... and the amount of pages can vary depending on the number of items up.

Is it possible for the web query to grab from all of the subsiquent pages as
well as the first one?
Thanks!!!

 

[Don Guillett]

Probably. Example urls and what you want.

 

[Guest]

Any sort of list item such as one here from ebay:
http://toys.search.ebay.com/toy-tra...Q_trksidZm37QQcatrefZC12QQfromZR40QQsacatZ717

Obviously there are 3 pages worth of items. My web query only pulls in the
first page. How do I get it to pull in all of the list items from however
many pages there may be?

 

[Don Guillett]

What you need to do is determine how many there are from the 1st fetch>

then copy the 1st fetch to another page >do a for 1=1 to 3 changing the url
with each fetch and copying the result to the next available row in the
consolidation sheet. Although a bit complicated it can be done and ALL from
Excel IF? you know the starting url.

In this case it is changing z00, z50, z100, etc Z100QQ