All code here is unprotected and free to re-use. For more details see Reusing code from this site.
The Color Arranger Sheets add-on is now available (free) in add-ons store. If you are interested in building add-ons you might find some useful stuff here as I've open sourced the code.
8 NEWEST THINGS
|Apps Script Add-ons and Office Add-ins. I try them out here first so I can take feedback before going through the Add-on publishing process.
||EzyOauth2 authentication. An Apps Script library that takes care of authentication to a number of services such as Google, Microsoft, Github and others. If the service you need isn't here, ask me.
|Integrate VBA projects with GitHub. A completely automated way of managing your VBA code, creating documentation on the fly, getting it to GitHub and creating workbooks directly from GitHub VBA code||Getting apps script projects to GitHub. Here's a completely automated way to get all your libraries, scripts and dependencies to github and keeping it all fresh.
4 MOST VISITED THINGS
4 MOST GEEKY THINGS
|Asynchronous GAS triggers.The quotas in Google Apps Script often get in the way of being able to do what you need to do. Here's a library to trigger multiple threads and execute them all at the same time.
||Automatic VBA documentation and creation of apps script skeletons. Creating automatic documentation by examining the functions and classes in a VBA project certainly saves some work. Here you'll find how to create Google Visualization and static tables of VBA projects, serialize instances of VBA classes and create a Google Apps Script skeleton of a VBA project|
You can get an index of the topics by hovering over the image below, along with some stats on pageviews and G+ popularity. Snap the index in position by clicking somewhere on it.
Since many of the hundreds of pages and examples on this site attach to and rely on external services (which may have changed or become unavailable), they may not work as initially designed - or even at all - and some may be out of date or reference deprecated services. Here are some of the other topics I've been playing around with for the past couple of years.
desktop liberation by bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines.