Deprecated
Google has now stopped its Earth API and Maps API is a paid for API nowadays. Some capabilities have also been either removed or changed. Therefore, I had to remove all examples of VizMap applications I had created. I didn’t remove the entire topic as I thought some of the code may still be useful with some modifications. 

VizMap: the Viz Html parameter Block

This parameter block is handled by cDataSet classes and is used to define the filename of the to be generated application. It also contains customization opportunities which will be explained in a later section.
For this example I had created a  Concerts/Venues example that is now deprecated. The complete workbook (googlemapping.xlsm) can be downloaded (above) and the example Parameter WorkSheet is called VenuesParameters.

Viz Html Parameter Block

The block for the example application we are using can be found in the VenuesParameters WorkSheet,  looks like this and is terminated by a blank line.

The filename parameter should be changed to point to the required directory and filename. In the example above ./ means the file should be created in the default directory.

Note that some directories on your machine may be readonly to you – for example if you have downloaded this and run it from the download directory on windows 8 you may not be able to create a file in that directory because of local permission settings. You should set this to a directory you have permission to create files in.

Notes

  1. This has been tested on IE, Firefox and Chrome. Depending on your security settings it may complain about running a local file. IE sometimes has problems with the Google Earth Plugin so that it doesnt show infoBubbles. Firefox sometimes hangs in the plugin. I will work on these behaviors to see if I can mitigate. Chrome is best.
  2. If desired, the generated file is self contained and can be directly published on a web site with no further modification needed.
  3. It does access various Google libraries and needs to be connected to the internet to work.
  4. The other parameter entries body and header are for customization of the web page and will be covered elsewhere.

Questions, feedback and VizMap applications you have generated can be submitted for loading to this site via our forum.  Next you should decide whether you need to decide whether you need to do geoCoding every time you generate your application, or whether you are going to use a fixed master sheet of pre-geoCoded data.