PDA

View Full Version : Extract Web Page Data



d4vem
02-20-2013, 02:20 PM
I am attempting to extract data from a web page that currently has 300+ products listed. This page on opening only shows 30 items until you scroll down through the entire page until all ALL 300+ items are displayed and are still displayed when scrolling up and down.

The problem is when I extract from the site I am returning 30 items and not the full 300+ items.

I would like to capture all products when querying the page. I attach the file that I am using. The URL is coded within the macro.

Any help would be much apprieciated.

snb
02-20-2013, 03:31 PM
Did you try to use a querytable ?

d4vem
02-22-2013, 10:01 PM
If you mean Data -> From Web. Yes I have and get exactly the same result

Thanks for the response