Web Query from multiple varying length pages
 

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

Web Query from multiple varying length pages
 

Probably. Example urls and what you want.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeffshex" wrote in message
...
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!!!

Web Query from multiple varying length pages
 

Any sort of list item such as one here from ebay:
http://toys.search.ebay.com/toy-trai...0QQsacatZ 717

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" wrote:

Probably. Example urls and what you want.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeffshex" wrote in message
...
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!!!

Web Query from multiple varying length pages
 

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
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeffshex" wrote in message
...
Any sort of list item such as one here from ebay:
http://toys.search.ebay.com/toy-trai...0QQsacatZ 717

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" wrote:

Probably. Example urls and what you want.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jeffshex" wrote in message
...
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!!!