PDA

View Full Version : VBA to search google maps in excel



colesre
12-16-2007, 12:12 PM
I currently have an excel invoice that I would like to create a form button to grab the address from the cell located in the invoice and bring up a map from google maps either in excel or a new window. If anyone has done this and can help much appriciated.

Bob Phillips
12-16-2007, 12:17 PM
Just use hyperlinks if you have the Google Map URL.

colesre
12-16-2007, 01:31 PM
that works just to open google, I would like macro or something to copy address from cell "M3" and incorporate into maps.google with auto enter. thank you. I did just try to record a macro and could not get excel to follow new window.