Extract Web Page Data

[d4vem]

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]

Did you try to use a querytable ?

[d4vem]

If you mean Data -> From Web. Yes I have and get exactly the same result

Thanks for the response