Link a map into excel based on city location

[Zimmerman]

I have a sheet that our salesman use to cost out what the price would be to do something. In here includes a spot to put the amount of miles it would be to deliver the product to the customer. What I'm wondering is, is it possible to have a link to a map that could be pulled up to show how many miles it actually is from start to end. Possibly even use the map for directions for our shipping department. Maybe it's not possible, but i have to ask.

Thanks
Windows XP
Excel 2003

 

[Ralajer]

There may be a more complicated yet better way to do it but you could just concatenate your address into a Google Maps URL.

Example a link for the direction from Transamerica Building in San Francisco to the Empire State Building would look like this

"http://maps.google.com/maps?f=d&source=s_d&saddr=600 Montgomery Street, San Francisco, CA&daddr=350 5th Avenue, New York, NY"
Where
saddr = Start Address
daddr = Destination Address

So if you used a formula such as this:

[A1] = 600 Montgomery Street, San Francisco, CA
[B1] = 350 5th Avenue, New York, NY
=HYPERLINK("http://maps.google.com/maps?f=d&source=s_d&saddr="&A1&"&daddr="&B1, "Map")

It might solve your problem.

 

[Zimmerman]

Thanks. I'll try it out and see what i come up with.