Excel Google Map Directions

[mtdew]

I have this code:

Private Sub Worksheet_Change(ByVal Target As Range)
ActiveWorkbook.FollowHyperlink "

http://maps.google.com/maps?f=d&source=s_d&saddr=650+9th+Ave,+AL+35020&daddr="

_
& Replace(Target.Value, " ", "+")

End Sub

Which provides directions from the office to the address found in cell B1. And it works in that it opens up the browser and displays the google page with directions and maps. What would be awesome is if the directions and maps from google could be placed back on the same sheet as cell B1 for printout. Is that possible?

 

[HarleyQuinn]

Google have a pretty strict policy on the use of their mapping facility.

What are you going to be using this for?

HarleyQuinn
---------------------------------
Black coat, white shoes, black hat, cadillac. The boy's a timebomb!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before post

 

[mtdew]

We sell and deliver storage buildings. We have an excel sheet set up for taking all the information in for delivery and billing but then we have to obtain the directions for delivery and paste it into the excel sheet. It would be helpful since we already have the starting address and ending address to be able to pull the directions from google or even mapquest or yahoo maps and incorporate it into the existing excel sheet automatically.