This is part of the Step by Step Guides to get started with some of the more complex topics on this site. The full story on vizMap applications can be found at Data Driven Mapping applications
GoogleMapping.xlsm from the Download Complete Projects page
Data Driven Mapping applications.
In How to define your vizMap application - Dictionary we covered defining fields that can be referenced in a vizMap application. Now its time to use them. Go to the step by step join sheet and launch the visualization button. This will fire off a Google Earth or Google Maps session that will look something like this, when you click on one of the markers. Note that the infoWindow has Tabs, and each tab will show a different view of your transactional data. For more detail on tabs see VizMap Tabs
Setting up tabs
You want to learn Google Apps Script?
Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas - from VBA to Apps script, available All formats are available now from O'Reilly,Amazon and all good bookshops. You can also read a preview on O'Reilly.
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation > Get Started Snippets > Step by Step Guides >