Web Query - additional web pages
 

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

Web Query - additional web pages
 

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



--
Don Guillett
SalesAid Software

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

Web Query - additional web pages
 

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.


--
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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

Web Query - additional web pages
 

On Jun 6, 10:57 am, Fiona wrote:
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

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