Extracting info from web pages
 

Hi,

i've looked on the web and other excel groups but i can't find anything
that'll help. Hopefully someone here can guide me toward the light..

What i'm trying to achieve is this;

i have a long list in Excel of hyperlinks, and i'm trying to come up with a
macro that will follow the first link, take certain data from the page,
paste it into a new sheet in the same workbook, and then follow the next
link in the next cell and repeat the process.

This is one of the links;

http://www.oxfordshire.gov.uk/wps/po...id=273#7_M_52R

and i want to get the Address, Headteacher etc down to the DFES number
information, to appear in the new sheet, followed by the next link, and the
next and so on. At this point it's no problem if all the info is pasted into
just the one cell, but it'd be nice if each line (Address: Ruskin Road,
Banbury, OX16 9HY for example) had it's own cell.

All the links are different, but the page format remains the same
throughout, btw.

i've tried recording a macro, but it only works for the same site and i
can't work out how to keep repeating the process.

i'm using Excel 2002 SP3 in WinXp.

If anyone can help it would save me hours, and would be much appreciated!

Thanks in advance,
\sh