Export a spreadsheet into google maps

[pausard]

Hey there,

So I have a spreadsheet right now that looks like this:
[TABLE="width: 580"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD]Name[/TD]
[TD]Surname[/TD]
[TD]Company[/TD]
[TD]Income[/TD]
[TD]Address[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]Smith[/TD]
[TD]General Motors[/TD]
[TD]100000[/TD]
[TD](Address1)[/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD]Jackson[/TD]
[TD]Hilton Hotels[/TD]
[TD]70000[/TD]
[TD](Address1)[/TD]
[/TR]
[TR]
[TD]Peter[/TD]
[TD]Jackson[/TD]
[TD]Hilton Hotels[/TD]
[TD]70000[/TD]
[TD](Address2)[/TD]
[/TR]
</tbody>[/TABLE]


What I want to do, is hitting a button with a macro behind it, export it to google maps and drop a pin in each of the addresses. Then, if possible, colour code them by the Surname (not super important but would be great).
Is there any way of doing this?
Thanks!

 

[John_w]

See http://ramblings.mcpher.com/Home/excelquirks/getmaps/mapmarkers. In the download workbook (googleMapping.xlsm), look at the venuemaster sheet and click the "Plot on a map - Google Maps" button. Note the code is very complicated and difficult to follow and some of it is redundant for your specific question because it covers other aspects of Google Maps.