Quick Links

Other stuff

Site owners

  • Bruce Mcpherson

Services‎ > ‎

Desktop Liberation

The aim of Desktop Liberation  and its related blog is to encourage you to take advantage of web capabilities without being constrained by your desktop software. You'll see a few techniques, tips and tricks for sure, as well as fully functional sample applications in various languages and frameworks, with a particular emphasis on Google Technology.  

All code is of course unprotected and free to re-use. For more details see Reusing code from this site. Examples are downloadable here

There are hundreds of pages and examples on this site, built up over time. Since many samples 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. If you find something like this, please comment on the forum.
4 newest things
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.
A VBA API for scriptDB
EzyOauth2. A Google apps script library to take the pain out of oAuth2, using the new stateTokenBuilder 
A VBA API for scriptDB
Abstracting the flavor of database from the code can help to postpone or change decisions about which one to use. Here's a complete Google Apps Script framework to handle standard requests to a variety of database back ends, including how to migrate off the now deprecated ScriptDB
A VBA API for scriptDB
A collection of Google Apps Script Snippets - I add a new one every few days. Contact me on the forum if you'd like to contribute some snippets.
A VBA API for scriptDB
4 most popular things
All about using JSON with Excel. Includes VBA classes that emulate javascript objects, parsing and stringifying JSON and dealing with data from external services. Includes a data driven REST-EXCEL library, and implementation of Google oAuth2 authentication
A VBA API for scriptDB
D3.js is a brilliant javaScript library for building complex interactive visualizations. Here's how to create them straight from Excel Data without needing to know any javaScript.
A VBA API for parse.com
Integrating Excel with Google Maps and Google Earth, including geoCoding, automatically building data driven web based apps from Excel data, and all things Geo.
A VBA API for scriptDB
Migrating from VBA to Google Apps Script, or using them simultaneously can be hard to get started with. Here's a number of projects translated from VBA to GAS, javascript primers, common VBA functions rewritten in javaScript and various other coexistence tools to help you on your way
A VBA API for scriptDB
4 most geeky things 
Using promises in javaScript and other languages is now the preferred way  to orchestrate the completion of asynchronous activities. Here's a promise implementation in VBA. Example includes getting data from Google Fusion tables
A VBA API for scriptDB
The mathematics of color is a complex and interesting topic. Here you'll find Google Apps Script, VBA and javascript examples of color manipulation including finding the closest match to a given color in a defined color scheme, and the infamous heatmap doughnut chart
A VBA API for parse.com
Mozilla open badges is a way of awarding digital badges for some measurable achievement. Here's a jquery implementation of it that integrates the Mozilla badge environment with Google Apps Script repository
A VBA API for scriptDB
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
A VBA API for scriptDB
Other stuff

Here are some of the other topics I've been playing around with for the past couple of years. 

Google jSon & javaScript VBA Excel  Other Stuff
Maps and Earth jSon - Excel vba Excel Connect
Maps,Earth and Excel jSon Getting started with VBA named ranges Forum
Using Google Maps How to use cJobject Get Started Snippets Array Formulas Blog
Using Google Earth Excel JSON conversion Dynamic Forms Bit Twiddling Content suggestions
Google Visualization Web Services SQL with vba Quirky Functions Scoops
Data Driven Applications jSon + Dynamic Forms One Liners Large ranges Trello
GeoCoding Cookies and Excel Recursion  Diminishing Returns Guest articles
Apps Script (GAS) Hiding data in Objects Countdown timer Equation plots in Excel Forum Gadget
VBA to Apps Script Rest - Excel library Optimization Snippets Using code from this site
Apps Script Library Rest Explorer classes How to do Stuff Other Reference Sites
Google Apps ScriptDB stringify VBA
Regular Expressions Outlook tagcloud Download Stuff
Sheet Caching cJobject JSON serialization
How to use cJobject
Step by Step Guides Downloads
GAS timers  javaScript cDataSet 
Strings and garbage Download Projects
GAS caching service VizMap javaScript Classes
Other stuff
Let GAS do the work ScriptDB as image store Color ramp library    Color Fiesta
GAS Delegation Proxy jsonp Charts and color ramps    Nearest color match
GAS and Sites  Twitter in Earth&Maps Hot doughnut    Assorted Snippets
GAS publishing Social links to sites Projects
Snippet of the day
Color Ramp scripts
Badges  Sudoku Generator

GAS color functions javaScript 'howTo' VBA autoupdate

Automatic VBA to GAS skeleton
tag clouds

Color Matching in GAS  Parse.com  Get Data from Outlook
GAS and sites Serving GAS to javaScript
Roadmap Generation

GAS lists and validation Color scheme explorer Auto documentation
Google Apps Scripts snippets
d3.js Module reference list    
Database abstraction with google apps script d3 and parse mashup Promises in VBA    
Other Googly stuff Flight data from Fusion Google Oauth2 VBA authentication    
Google Books   Node focus on Blogger posts Regex, scraping and visualizing    
University Rankings visualized d3 concept browser XML to JSON with VBA    
Data From Google Docs  Delegating xml to json conversion to GAS Instrumenting VBA for Google Analytics    
pinyin conversions  Oauth2 and Excel-Rest library parse.com - nosql database for VBA    
parse.com - noSQL database for GAS  scriptDB API for JavaScript  Data driven VBA apps with JSON    
Google Docs  Apps built with data abstraction A VBA API for scriptDB    
Visualization tables         
Creative Commons License Excel Liberation and related blog are licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.

Get involved

Subpages (72): View All