PDA

View Full Version : Getting data from a website in Excel


Oxeagle
17th Nov 2006, 09:46
Right, previous problems solved, now for the next one! At the moment, whenever I want to find the co-ordinates of a place I have to use the website http://www.streetmap.co.uk/gridconvert.html to convert the post code. If I want to do this automatically, how would I go about doing it? Basically, this is what I want to happen: I type a post code into a cell. I then activate a macro, which opens the website, enters the post code into the search box and copies the resulting co-ordinates into the spreadsheet. Is this possible? If so, how would I go about doing it?
Many thanks,

Ox :)