Web Query - additional web pages

F

Fiona

Hi,
Does anyone know how to import data from a website that has numerous page
containing relevant data?

e.g. searching for a particular item, the website show 10 pages that have
the relevant item, I want to import dat from each of those 10 pages?

Thanks
 
D

Don Guillett

Import the whole thing and use a macro or formulas to take to another sheet,
as desired.
 
D

David McRitchie

The process is call "screen scraping"
suggest you do a google web search on either of these
excel screen-scraping
screen-scraping excel quotes
and one in Google Groups for
group:*excel* screen-scraping

Of course anything you write is subject to the pages being
changed, and especially if you just collecting someone else's data.
 
A

alex

Hi,
Does anyone know how to import data from a website that has numerous page
containing relevant data?

e.g. searching for a particular item, the website show 10 pages that have
the relevant item, I want to import dat from each of those 10 pages?

Thanks
Click to expand...

It can be easily done with SWExplorerAutomation (SWEA) from http://webiussoft.com.
 
Top