What to downloadAll 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 belowNote 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 or Google Plus 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. |
Services > Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation >
Downloads
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|
github stuff| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
|
ċ
|
View |
This is the repo for GitHub/VBA integration | Mar 23, 2015, 4:16 AM | Bruce Mcpherson | |||
| Ĉ | View Download |
You'll need this to get started with VbaGit | 296k | v. 11 | Apr 18, 2017, 2:46 AM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
|
ċ
|
Download |
demonstrate the use of array formulas and optimization with MAtCH() | 3962k | v. 2 | Jan 17, 2012, 9:35 PM | Bruce Mcpherson | |
| Ĉ | View Download |
608k | v. 2 | Dec 13, 2013, 10:10 AM | Bruce Mcpherson | ||
| Ĉ | View Download |
examples of google apps script blister custom functions being accessed directly from excel | 277k | v. 2 | Sep 30, 2013, 4:39 AM | Bruce Mcpherson | |
| Ĉ | View Download |
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 | 3989k | v. 264 | Apr 18, 2017, 2:46 AM | Bruce Mcpherson | |
|
ċ
|
View |
This is a fore diagram representation of some test data from the iTunes database | Jun 24, 2012, 5:54 AM | Bruce Mcpherson | |||
| Ĉ | View Download |
547k | v. 5 | May 3, 2014, 12:27 PM | Bruce Mcpherson | ||
| Ĉ | View Download |
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 | 462k | v. 8 | Apr 18, 2017, 2:47 AM | Bruce Mcpherson | |
| Ĉ | View Download |
407k | v. 2 | Apr 10, 2013, 1:45 AM | Bruce Mcpherson | ||
|
ċ
|
View |
You can get the shared restLibrary Google Workbook here. To access the scripts, go to file and make a copy. | Nov 1, 2012, 4:26 AM | Bruce Mcpherson | |||
| Ĉ | View Download |
import data into excel from google spreadsheets - oauth2 is implemented | 430k | v. 3 | Oct 15, 2013, 2:53 AM | Bruce Mcpherson | |
|
ċ
|
Download |
20k | v. 2 | Feb 18, 2013, 3:18 AM | Bruce Mcpherson | ||
| Ĉ | View Download |
use this to contain all your oauth2 credentials. It only needs to be run once | 292k | v. 2 | Nov 22, 2013, 4:28 AM | Bruce Mcpherson | |
| Ĉ | View Download |
This is a basic implementation of promises in vba to handle orchestration of asynchronous activities | 574k | v. 7 | Aug 9, 2013, 3:01 AM | Bruce Mcpherson | |
|
ċ
|
Download |
This is the online rest library. Will be updated with additional entries from time to time | 3k | v. 3 | Apr 12, 2012, 10:27 AM | Bruce Mcpherson | |
|
ċ
|
Download |
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 | 15k | v. 3 | May 29, 2012, 3:42 AM | Bruce Mcpherson | |
| Ĉ | View Download |
239k | v. 5 | Jan 17, 2017, 3:58 AM | Bruce Mcpherson | ||
| Ĉ | View Download |
193k | v. 2 | May 6, 2015, 4:02 AM | Bruce Mcpherson | ||
| Ĉ | View Download |
189k | v. 3 | May 11, 2015, 4:15 AM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
| Ĉ | View Download |
237k | v. 2 | Mar 8, 2017, 3:30 AM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
| Ĉ | View Download |
An example workbook that creates google visualizations and embeds them in your worksheet, as well as standalone .html and serialized data files | 272k | v. 14 | Apr 25, 2012, 8:09 AM | Bruce Mcpherson | |
|
ċ
|
Download |
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 | 1k | v. 6 | Jan 14, 2011, 9:12 AM | Bruce Mcpherson | |
|
ċ
|
Download |
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 | 2k | v. 6 | Jan 26, 2011, 5:54 AM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
|
ċ
|
Download |
A general purpose countdown timer or progress Bar which can use either form controls or excel shapes as a template. | 112k | v. 4 | Jan 9, 2011, 8:44 PM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
|
ċ
|
Download |
Get Data from Outlook classes and example | 82k | v. 2 | May 27, 2011, 11:36 AM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
| Ĉ | View Download |
Contains all the code referenced in the getting started snippets section | 347k | v. 13 | Mar 20, 2012, 11:05 AM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
|
ċ
|
View |
Bootstrap code. This will get you started maintaining your VBA code automatically | Aug 21, 2012, 5:31 AM | Bruce Mcpherson | |||
|
ċ
|
View |
xml manifest for use with gistthat for cDataSet and cJobject | Aug 21, 2012, 5:30 AM | Bruce Mcpherson | |||
| Ĉ | View Download |
bootstrap code and examples for maintaining vba code automatically using github | 60k | v. 8 | Aug 24, 2012, 6:28 AM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
|
ċ
|
View |
Link for general purpose google gadget to add tracking code for google analytics | Apr 18, 2011, 5:10 AM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
|
ċ
|
Download |
Bing version generated by Excel to plot data on Bing maps | 5k | v. 2 | Sep 7, 2011, 4:13 AM | Bruce Mcpherson | |
| Ĉ | View Download |
this is a test version to deal with mismatched excel and browser locale | 788k | v. 3 | Jul 15, 2013, 5:45 AM | Bruce Mcpherson | |
| Ĉ | 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. | 855k | v. 78 | Mar 6, 2017, 7:59 AM | Bruce Mcpherson | |
|
ċ
|
Download |
This is generated when you use the test data to place customer markers on google maps. | 8k | v. 6 | Mar 28, 2012, 5:50 AM | Bruce Mcpherson | |
|
ċ
|
Download |
kml markers for use with google earth. Example generated by googleMapping.xlsm | 2k | v. 2 | Oct 13, 2011, 2:49 AM | Bruce Mcpherson | |
|
ċ
|
Download |
Ovi Maps version of mapped Excel data | 5k | v. 2 | Sep 6, 2011, 9:55 AM | Bruce Mcpherson | |
|
ċ
|
Download |
British Royal family and their homes - Generated VizMap application - Google Earth version | 81k | v. 7 | Nov 12, 2011, 2:03 AM | Bruce Mcpherson | |
|
ċ
|
Download |
British royal family and their homes - generated Google Maps VizMap application | 81k | v. 5 | Nov 12, 2011, 2:03 AM | Bruce Mcpherson | |
|
ċ
|
Download |
Earth version of customer/orders vizmap generated application | 48k | v. 4 | Nov 12, 2011, 2:04 AM | Bruce Mcpherson | |
|
ċ
|
Download |
VizMap generated application. Customer/Orders visualization | 48k | v. 5 | Nov 12, 2011, 2:04 AM | Bruce Mcpherson | |
|
ċ
|
Download |
Google Earth example showing integration with Org charts and twitter | 59k | v. 2 | Nov 22, 2011, 1:49 AM | Bruce Mcpherson | |
|
ċ
|
Download |
Google Maps example showing integration with Org charts and twitter | 59k | v. 2 | Nov 22, 2011, 1:49 AM | Bruce Mcpherson | |
|
ċ
|
Download |
Palace vizmap using google earth instead of maps | 47k | v. 6 | Nov 12, 2011, 2:05 AM | Bruce Mcpherson | |
|
ċ
|
Download |
VizMap generated application. Dictators/Palaces visualization | 47k | v. 5 | Nov 12, 2011, 2:05 AM | Bruce Mcpherson | |
|
ċ
|
Download |
Google Earth version of generated venues application | 50k | v. 5 | Nov 12, 2011, 2:06 AM | Bruce Mcpherson | |
|
ċ
|
Download |
VizMap generated application. Artist/Venues visualization | 50k | v. 6 | Nov 12, 2011, 2:06 AM | Bruce Mcpherson | |
|
ċ
|
Download |
Excel data marked up on a Yahoo Map | 4k | v. 3 | Oct 8, 2011, 3:41 AM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
|
ċ
|
View |
All the files you need to embed a roadmapper gadget | Mar 21, 2011, 1:44 PM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
|
ċ
|
Download |
This is the example workbook to illustrate the serialization and deserialization of JSON data and hiding it in shapes, cells and cookies | 92k | v. 6 | Aug 10, 2011, 3:10 AM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
|
ą
|
View Download |
heat map version 1 | 40k | v. 3 | Jan 5, 2012, 8:07 AM | Bruce Mcpherson | |
|
ą
|
View Download |
heatmapversion 2 | 32k | v. 3 | Jan 5, 2012, 8:07 AM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
| Ĉ | 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 | 56k | v. 3 | Mar 21, 2012, 2:47 AM | Bruce Mcpherson | |
|
ċ
|
Download |
Optimization Package: Includes worksheet analyzer, procedure profiler, and automatic profiler as excel Add-ins | 75k | v. 4 | Jan 9, 2011, 8:43 PM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
| Ĉ | View Download |
94k | v. 2 | Sep 2, 2013, 10:39 AM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
|
ċ
|
View |
This is the open source project for the google gadget visualization version of this. | Apr 8, 2011, 8:23 AM | Bruce Mcpherson | |||
|
ċ
|
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 | Apr 13, 2012, 12:29 AM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
| Ĉ | View Download |
432k | v. 3 | Jan 30, 2013, 11:19 AM | Bruce Mcpherson | ||
| Ĉ | View Download |
Constraint formulas to find the rule for identifying naked sets in sudoku. Also demonstrates the use of bittwiddling functions | 75k | v. 5 | Oct 12, 2012, 4:52 AM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
|
ċ
|
Download |
Example of UDF and formula for calculating diminishing returns | 18k | v. 2 | Jun 4, 2011, 3:09 AM | Bruce Mcpherson | |
|
ċ
|
Download |
Regex package for executing regEX patterns as UDF, as well as a regex library capability. | 34k | v. 3 | Nov 28, 2011, 11:29 AM | Bruce Mcpherson |
| Selection | File type icon | File name | Description | Size | Revision | Time | User |
|---|---|---|---|---|---|---|---|
|
ċ
|
Download |
deprecated:An empty workbook containing only the classes needed to be able to use cDataSet and cJobject | 215k | v. 7 | Nov 22, 2011, 1:50 AM | Bruce Mcpherson | |
|
ċ
|
Download |
Change color based on cell value using a command button rather than worksheet event. | 21k | v. 4 | Sep 3, 2011, 4:49 AM | Bruce Mcpherson | |
|
ċ
|
Download |
change the background color of a cell to the same as another in the same column based on a value. from http://www.eggheadcafe.com/forumpostsubmission.aspx?topicid=66&forumpostid=10226616 | 18k | v. 5 | Sep 3, 2011, 4:49 AM | Bruce Mcpherson | |
| Ĉ | View Download |
Using dynamic ranges in charts. http://www.eggheadcafe.com/community/aspnet/66/10226737/xaxis-range-change.aspx | 15k | v. 4 | Sep 3, 2011, 4:49 AM | Bruce Mcpherson | |
|
ċ
|
View |
This is a version of the roadmapper implemented as a google gadget. | Apr 23, 2015, 11:59 AM | Bruce Mcpherson | |||
|
ċ
|
Download |
Make shapes with size based on a range. http://www.eggheadcafe.com/community/aspnet/66/10251513/creating-autoshapes-using-vba-for-excel-2003.aspx | 16k | v. 5 | Sep 5, 2011, 11:12 AM | Bruce Mcpherson | |
|
ċ
|
Download |
Example Sheet and add in .bas for worksheet optimizer | 28k | v. 5 | Sep 3, 2011, 4:49 AM | Bruce Mcpherson | |
|
ċ
|
Download |
Code snippet to randomize timesheet completion. http://www.eggheadcafe.com/community/aspnet/66/10225953/macro-to-randomly-autofill-time-tracking.aspx | 18k | v. 6 | Sep 3, 2011, 4:49 AM | Bruce Mcpherson | |
|
ċ
|
Download |
For randomly populating a range with unique numbers. | 18k | v. 5 | Sep 5, 2011, 11:12 AM | Bruce Mcpherson | |
|
ċ
|
Download |
deprecated:Demonstrate the use of regular expressions | 17k | v. 5 | Sep 3, 2011, 4:49 AM | Bruce Mcpherson | |
|
ċ
|
Download |
Roadmap generator- Dynamic forms and clickable roadmaps. V3 - Note that the latest version of roadmapper is now maintained in cDataSet.xlsm | 419k | v. 15 | Jul 27, 2012, 6:16 AM | Bruce Mcpherson | |
| Ĉ | View Download |
Deprecated:Starter Parameter worksheet: Get started with a skeleton parameter sheet for your roadmap | 16k | v. 5 | Sep 3, 2011, 4:49 AM | Bruce Mcpherson | |
|
ċ
|
Download |
Deprecated:CDataSet Package: class files plus stress Test procedures. Please download cDataSet.xlsm instead | 150k | v. 6 | Sep 3, 2011, 4:49 AM | Bruce Mcpherson | |
|
ċ
|
Download |
Test workbook for cProcProfiler | 17k | v. 4 | Sep 3, 2011, 4:49 AM | Bruce Mcpherson | |
|
ċ
|
Download |
Deprecated:Useful User defined functions referenced throughout this site | 23k | v. 7 | Sep 5, 2011, 11:12 AM | Bruce Mcpherson |