Web Query from multiple varying length pages

J

Jeffshex

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!!!
 
D

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
 
Top