Web Query question
 

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,

Web Query question
 

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

"sb1920alk" wrote in message
...
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,

Web Query question
 

I sent you an email.

"Don Guillett" wrote:

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

"sb1920alk" wrote in message
...
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,

Web Query question
 

I sent OP a file using mapquest

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
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

"sb1920alk" wrote in message
...
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,