Scrape GPS Coordinates in to Excel?

Does anyone know of a way to get GPS Coordinates from a site like Yahoo or Google and into Excel?

I’m wanting to create a spreadsheet where a user can enter an address and then execute a Macro that will send the Address to Yahoo or Google and then get the GPS Coordinates back for that address. These Coordinates would then be compared against a Database of other records.

Here’s what I now already:
– In Yahoo Maps: When logged in with a Yahoo ID, the Latitude and Longitude shows up in the address bar after searching for the address.
– In Google Maps: After a search is done the Latitude and Longitude are in the source code and can be scraped out by using a text identifier like “lat:” or “lng:”

I’ve done this in FileMaker, but think for this user Excel would be the best option. (I would be willing to try this with PHP or Python too if that is a better option)