Web Query - additional web pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Import the whole thing and use a macro or formulas to take to another sheet,
as desired.
 
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.
 
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.
 
Back
Top