Services‎ > ‎

Desktop Liberation - the definitive resource for Google Apps Script and Microsoft Office automation


Desktop Liberation and its related blog and G+ community aims to help you to use cloud based APIS and services without being constrained by your desktop software. There's a particular emphasis on Google APIs and JavaScript, but there's also plenty of Microsoft and other stuff here too. All code here is unprotected and free to re-use. For more details see Reusing code from this site

8 NEWEST THINGS
Going Gas. Abridged extracts from my book - Going Gas: from VBA to Apps Script. Featuring examples of the new Execution API.
A VBA API for scriptDB
Goa 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.
A VBA API for scriptDB
Standard noSQL interface to lots of different DBs. 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 standardized requests to a variety of database back ends.
A VBA API for scriptDB
A collection of Google Apps Script/JavaScript snippets. I add a new one every now and again.  A good place to start if you just want to get a feel for Apps Script, ranging from everyday simple to esoteric and obscure
A VBA API for scriptDB
Integrate VBA projects with GitHubA 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
A VBA API for scriptDB
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.
A VBA API for scriptDB
Integrate VBA with JavaScriptRun JavaScript code directly in VBA from JS libraries on the Internet, or created locally. Opens up great possibilities for using Open Source stuff in VBA
A VBA API for scriptDB
Bigquiz app. This is a complete Apps Script webapp that brings together many Googlish things, such as Firebase, Material design, multiple OAuth2 flows, BigQuery and other topics  from this site.
A VBA API for scriptDB
4 MOST VISITED THINGS
JSON and Excel. 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. 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
MAPS and Earth. 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
From VBA to Apps Script. 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 
Promises and Excel. 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
Color Mathematics. 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
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.
A VBA API for scriptDB
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
A VBA API for scriptDB





There are over 700 topics in this site. You can get a summary of them 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, or use the side menu to find something of interest.





Creative Commons License

desktop liberation
 by bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International LicenseBased on a work at http://www.mcpher.comPermissions beyond the scope of this license may be available at code use guidelines.

Subpages (87): View All
Comments