Download Complete Projects

This is a summary of the downloadable completed projects on this site. The complete set of additional and related downloads can be found here.

What to download

All the examples contain all the classes needed for them to work and all projects can be found on this page. If you just want the main utility classes used throughout this site, in the Downloads section cDataSet.xlsm includes everything you need including some examples.

Countdown timer  ProgressBarExcel/VBACount down timer using any Excel shape 
Creating Google Maps Layers from Excel Data  Google Maps
Google Mapping/Earth/Visualization 
Accessing Google MAPS and Google Earth API directly from Excel. Geocoding, marking and combining with Google Visualization to generate complete data driven applications 
Data Manipulation Classes  cDataSet  Excel/Vba/jSon A set of VBA classes to abstract data from physical sheet location
Execution Time Logging  Workbook Profiler Excel/VBA Report on cell based recalculation performance in worksheet. A more fully functional version of this is in the procprofiler package
From VBA to Google Apps Script  Google Roadmapper Spreadsheet Google Apps Script  You will need to log into a google account to use this. use file/make a copy to get your own private version. This is is the Google Apps Script conversion of the roadmapper project. 
Get Data From Google Docs  Built into cDataSet  Excel/Vba/jSon  Gets data from Google docs straight into Excel 
Get Data from Outlook OutlookLookupExcel/VBA Get Data from Outlook global address list 
Get Started Snippets  Getting Started WorkbookExcel/VBA Code referenced in the getting started series of snippets
Google Analytics tracker  analytics gadget  Google Gadget A gadget to inject analytics tracking in any web page
Google Script Color Ramp Google Apps Script Color Ramp Document  Google Apps Script Log into Googleand use file/copy to make your own private copyto access this google doc and the apps script code 
Google Visualization GoogleChartsGoogle Visualization Create Google Visualizations from Excel Data
Hiding data in Excel Objects TrackingDataExcel/Vba/jSon Serialize data inJSON and store in Excel objects or cookies
Roadmap Generation  Excel version of Roadmapper  Excel/Vba/jSon Roadmapper – note that this is now part of in cDataSet.xlsm 
Sudoku Generator and Solver ExceldokuExcel/VBA Sudoku Generator and Solver 
VBA profiler procprofilerExcel/VBA Automatic profiling of VBA functions