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

8 Newest things
Going Gas. Abridged extracts from my book - Going Gas: from VBA to Apps Script. Featuring examples of the new Execution API. Going Gas Goa authentication. An Apps Script library that takes care of authentication to a number of services such as Google, Microsoft, Github and others. A VBA API for scriptDB
Standard noSQL interface for various 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. Going Gas 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.
Going Gas
Integrate VBA projects with GitHub. An automated way of managing your VBA code, creating documentation on the fly, getting it to GitHub and creating workbooks directly from GitHub VBA code.
Going Gas
Getting apps script projects to GitHub. An automated way to get all your libraries, scripts and dependencies to github and generating automatic documentation.
Going Gas
Integrate VBA with JavaScript. Run JavaScript code directly in VBA using JS libraries on the Internet, or created locally. Opens up great possibilities for using Open Source code in VBA
Going Gas
Google Cloud Storage with Apps ScriptThis introduces a library that simplifies access to Google Cloud storage from Apps Script and can be used as an alternative to Properties Service
Going Gas

4 most visited things
JSON and Excel. JSON and Excel using 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
Going Gas
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, as well as some non-Excel examples.
Going Gas
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.
Going Gas
From VBA to Apps Script. Migrating from VBA to Google Apps Script, or using them simultaneously can be hard to get started with. Although this material has been largely superceded by Going Gas, there's stll some useful stuff here.
Going Gas

4 most geeky things
Promises and Excel. Using promises in JavaScript and other languages is the preferred way  to orchestrate the completion of asynchronous activities. Here's a (not perfect but fun) Promise implementation in VBA. Example includes getting data from Google Fusion tables.
Going Gas
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.
Going Gas
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.
Going Gas
Automatic VBA documentation and creation of apps script skeletons. Automating document ,creating Google Visualization and static tables of VBA projects, serialize instances of VBA classes and generating Google Apps Script skeleton of VBA projects.
Going Gas

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 (63): View All
Comments