What to download

All the individual downloadable items referenced in this site can be found here. Please scroll down to find the package(s) you want.  The 2 most likely ones are cDataSet.xlsm or GoogleMapping.xlsm which you’ll find in the googlemapping and data manipulation folders below.

Note that there is a huge amount of samples and code in these workbooks, and you won’t need most of it.  However, you can update your own workbook or create an empty one with selected code online  automatically  – see this post Integrate VBA with Github.

Everything on this site is free to use. See Reusing code from this site for more details. If you find something of use, please share it on your favorite social network or tweet about it.

For help and more information join our forum, follow the blog or follow me on twitter.

Google Analytics

Google Analytics is used to in some workbooks to see what is popular, and what versions of what are being used  – see Instrumenting VBA for Google Analytics for details. You can read how I use this on this post.

No personally identifiable information is stored as per Google Terms of Service. If you have problems (no internet connection or proxy problem, or otherwise want to opt out of that),  please follow the instructions below, and modify your copy of what you have downloaded.

You can easily opt out of google analytic reporting by setting pOptOut to true in the cUAMeasure class as below.

 Private Sub Class_Initialize()    Set pBrowser = New cBrowser    ' change this to true to opt out of analytic reporting    pOptOut = False

Click on the table below to access the downloadable artefacts

Github stuff
Data Manipulation
effex
Embedding Google visualizations in Excel and serializing Excel Data
General purpose Countdown Timer or Progress Bar
Get Data from Outlook
Getting Started Snippets
gistThat
Google Analytics
Google Mapping
Google Visualization implementation of Roadmapper
Hiding Data in Excel Objects and JSON serialization
Images
Optimization
Pinyin
Roadmapper Project
Sudoku Solver and Generator Project
Useful user defined Functions
Github stuff

View VbaGitBootstrap on github. This is the repo for GitHub/VBA integration 

View or Download VbaGitBootStrap.xlsm. You’ll need this to get started with VbaGit 

Data Manipulation

View Download arrayformulas.xlsm – demonstrate the use of array formulas and optimization with MAtCH() 

View Download bitCoinAuto.xlsm  –

View Download blisterFunctions.xlsm –examples of google apps script blister custom functions being accessed directly from excel 

View Download cDataSet.xlsm –CdataSet – class files for caching and working with structured excel data and parameters. Also includes Excel/jSon/Excel,d3.js, an Excel/Rest library and various other examples


View d3Force interactive example –This is a fore diagram representation of some test data from the iTunes database

View Download dbabstraction.xlsm

View Download emptycdataset.xlsm –This is a version of cDataSet that only contains the most useful classes and modules, and has no samples. You can download this for a clean version to build upon 

View Download funnycharts.xlsm

View Google apps version of rest library –You can get the shared restLibrary Google Workbook here. To access the scripts, go to file and make a copy.

View Download googleImport.xlsm –import data into excel from google spreadsheets – oauth2 is implemented 

View Download horsesankey.html

View Download oauth2credentials.xlsm –use this to contain all your oauth2 credentials. It only needs to be run once.

View Download promises.xlsm –This is a basic implementation of promises in vba to handle orchestration of asynchronous activities 

View Download restLibrary.html –This is the online rest library. Will be updated with additional entries from time to time 

View Download sankey.html –this is a sankey diagram using d3.js generated out of Excel. Note – probably doesnt work on IE8 and below. Use firefox or chrome if you can

View Download sheetsApi.xlsm

View Download vanillaChromeTrace.xlsm

View Download vanillacJobject.xlsm


 

 




 






effex

View Download effex-demo-markers-excel.xlsm

Embedding Google visualizations in Excel and serializing Excel Data

View Download googleCharts.xlsm –An example workbook that creates google visualizations and embeds them in your worksheet, as well as standalone .html and serialized data files.

View Download  googleMotionWrapper.html- A skeleton .html file with the code needed to show a google motion chart. Will take serialized data created by the example workbook or from googleDocs.

View Download googleVisWrapper.html: A wrapper that will create google visualizations. It needs a dataURL containing the Excel data in JSON format. This serialized data is created by the googlecharts.xlsm example application.

 

General purpose Countdown Timer or Progress Bar

ProgressBar.xlsm
View Download
A general purpose countdown timer or progress Bar which can use either form controls or excel shapes as a template.  

Get Data from Outlook

outlookLookup.xlsm
View Download
Get Data from Outlook classes and example

Getting Started Snippets

gettingstartedSeries.xlsm
View Download
Contains all the code referenced in the getting started snippets section

gistThat

bootstrap code for gisThat VBA
View
Bootstrap code. This will get you started maintaining your VBA code automatically
cDataSet gistthat manifest
View
xml manifest for use with gistthat for cDataSet and cJobject
gistThat.xlsm
View Download
bootstrap code and examples for maintaining vba code automatically using github

Google Analytics

Google Analytic Gadget
View
Link for general purpose google gadget to add tracking code for google analytics

Google Mapping

bingMarkerGenerated.html
View Download
Bing version generated by Excel to plot data on Bing maps
GoogleMappinglocale.xlsm
View Download
this is a test version to deal with mismatched excel and browser locale
GoogleMapping.xlsm
View Download
Generate complete VizMap applications for Google Earth or Google Maps that combine mapping, visualization and twitter. Use mapping APIs to extract address components from a table of Excel unstructured addresses and plot them directly on Google Maps, Yahoo Maps, Bing Maps, Ovi Maps and Google Earth
googleMarkerGenerated.html
View Download
This is generated when you use the test data to place customer markers on google maps
kmlMarkerGenerated.kml
Download
kml markers for use with google earth. Example generated by googleMapping.xlsm
oviMarkerGenerated.html
View Download
Ovi Maps version of mapped Excel data
vizMapFamilyGeneratedEarth.html
View Download
British Royal family and their homes – Generated VizMap application – Google Earth version
vizMapFamilyGenerated.html
View Download
British royal family and their homes – generated Google Maps VizMap application
vizMapOrdersGeneratedEarth.html
View Download
Earth version of customer/orders vizmap generated application
vizMapOrdersGenerated.html
View Download
VizMap generated application. Customer/Orders visualization
vizMapOrgGeneratedEarth.html
View Download
Google Earth example showing integration with Org charts and twitter
vizMapOrgGenerated.html
View Download
Google Maps example showing integration with Org charts and twitter
vizMapPalacesGeneratedEarth.html
View Download
Palace vizmap using google earth instead of maps
vizMapPalacesGenerated.html
View Download
VizMap generated application. Dictators/Palaces visualization
vizMapVenuesGeneratedEarth.html
View Download
Google Earth version of generated venues application
vizMapVenuesGenerated.html
View Download
VizMap generated application. Artist/Venues visualization
yahooMarkerGenerated.html
View Download
Excel data marked up on a Yahoo Map

Google Visualization implementation of Roadmapper

Roadmapper package
View
All the files you need to embed a roadmapper gadget

Hiding Data in Excel Objects and JSON serialization

trackingData.xlsm
View Download
This is the example workbook to illustrate the serialization and deserialization of JSON data and hiding it in shapes, cells and cookies

Images

757.png
View
heat map version 1
758.png
View
heatmapversion 2

Optimization

optimizeExample.xlsm
View Download
This is just if you want a very simple reporting on sheet calculation. A more fully featured version in included in the procprofiler package
procProfiler.zip
Download
Optimization Package: Includes worksheet analyzer, procedure profiler, and automatic profiler as excel Add-ins

Pinyin

pinyin.xlsm
View Download

Roadmapper Project

Gadget Source
View
This is the open source project for the google gadget visualization version of this
Link to google Apps Script Roadmapper
View
This is the Google Apps Script version of the roadmapper. You should use file/make a copy to make your own proivate copy to access the code

Sudoku Solver and Generator Project

ExcelDoku.xlsm
View Download

sudbittwiddle.xlsm
View Download
Constraint formulas to find the rule for identifying naked sets in sudoku. Also demonstrates the use of bittwiddling functions

Useful user defined Functions

diminishingreturn.xlsm
View Download
Example of UDF and formula for calculating diminishing returns
rxLib.xlsm
View Download
Regex package for executing regEX patterns as UDF, as well as a regex library capability