Is there any macro or formula that would allow me to highlight an address on a spread sheet, then hit a button, and have google open up and go to that location on google maps?
Is there any macro or formula that would allow me to highlight an address on a spread sheet, then hit a button, and have google open up and go to that location on google maps?
OK, so I am halfway there. I can use the following to open internet explorer and search for a defined topic. In this example, it is searching for New YOrk Knicks. How would I get it to search on a string of text in a cell/s?
Sub Sample()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True
IE.Navigate ("http://www.google.com/#hl=en&q=" & "New York Knicks") '<~~ US
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks