Error inserting google map in excel

Question

Hello,

Could you please let me know how it is possible to insert google map in excel file.

My steps are : Developer=>Insert=>More Controls=>Microsoft Web Browser but in the end i'm receiving a note that it cannot be inserted. Why is it happening?

Regards

Polina

***Post moved by the moderator to the appropriate forum category.***

Answer 1

What exactly are you trying to do.

If it's just displaying an image from Google Maps in an Excel Workbook use Snagit from www.techsmith.com to capture the part of the map that you want and then copy it from the Snagit editor and paste it into Excel.

To call Google Maps from an address in cells A2, B2, C2 containing Street, City, State using a macro, use:

Sub GetGoogleMaps()

Dim r As Long

Dim strURL As String

r = 2 ' change in your code if the address is in some other row.

strURL = "http://maps.google.com/maps?q="

strURL = strURL & Replace(Range("A" & r), " ", "+")

strURL = strURL & "+" & Replace(Range("B" & r), " ", "+")

strURL = strURL & "+" & Replace(Range("C" & r), " ", "+")

ActiveWorkbook.FollowHyperlink strURL

End Sub