Web Query question

[sb1920alk]

I'm not sure if this is possible or not. I have a spreadsheet that makes
calculations based on the distance between two zip codes that are entered by
the user. Right now I'm using a table listing each zip code and it's latitude
and longitude, and a formula for the distance between two points on a sphere.

What I really need is the distance by road between the two zip codes.

So, is there any way that when something happens (a macro is run, or a value
is entered in a cell, etc.) that excel can take the two zip codes that the
user entered and plug them in to google map's driving directions, and then
return the number of miles that google maps provides to a third cell?

Thanks in advance,

 

[Don Guillett]

I once designed a program using Yahoo that doesn't seem to work anymore. I
just tried Google without success but Mapquest allowed me to input zips and
right click the table to import to Excel. I then recorded a macro to refresh
with variables and find the time and distance. Contact me privately if
necessary.
http://www.mapquest.com/maps/78734/78654
Total Estimated Distance: 37.95 miles

 

[sb1920alk]

I sent you an email.

I once designed a program using Yahoo that doesn't seem to work anymore. I
just tried Google without success but Mapquest allowed me to input zips and
right click the table to import to Excel. I then recorded a macro to refresh
with variables and find the time and distance. Contact me privately if
necessary.
http://www.mapquest.com/maps/78734/78654
Total Estimated Distance: 37.95 miles

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[Don Guillett]

I sent OP a file using mapquest