Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
extracting info related to maching entries | Excel Discussion (Misc queries) | |||
compling info from multiple pages onto one page? | Excel Worksheet Functions | |||
Distribute info from "summary" page to separate pages under condition | Excel Worksheet Functions | |||
FU: Distribute info from "summary" page to separate pages under condition | Excel Worksheet Functions | |||
Extracting info from word and displaying in an excel spreadsheet | Excel Discussion (Misc queries) |