Ramblings

Welcome to Desktop Liberation

The definitive resource for Google Apps Script and Microsoft Office automation

I am a Google Developer Expert and decided to investigate Google Apps Script in my spare time.

The more I investigated the more content i created so this site is extremely rich. Now, in 2019, a lot of things have disappeared or don’t work anymore due to Google having retired some stuff. I am however leaving things as is and where I came across some deprecated stuff, i have indicated it.

I decided to write a book about it and to also create videos to teach developers who want to learn Google Apps Script. If you find the material contained in this site useful, you can support me by buying my books and or videos.

Book


For those who prefer book and eBook formats, a 450+ page deep dive into Apps Script. Especially useful for those transitioning from another platform.
All formats are available from O’ReillyAmazon and all good bookshops. You can also read a preview on O’Reilly

Video training


An accelerated video course over about 8 hours and 70 lessons taking you through JavaScript and Apps Script from start to finish.
Available at O’ReillyInfinite Skills and all good media outlets

Menu Item 3

A video course over about 8 hours and 70 lessons taking you through the basics of Apps Script and JavaScript .
Available at O’ReillyInfinite Skills and all good media outlets. 

This site and its  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.

Since the creation of this website, I have noticed that the below topics are by far the most popular

Most Visited Pages

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 authenticationD3.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.
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.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.

The 7 topics below are the most recently published

7 newest things

Going Gas Gas. Abridged extracts from my book – Going Gas: from VBA to Apps Script. Featuring examples of the new Execution API.Goa authentication. An Apps Script library that takes care of authentication to a number of services such as Google, Microsoft, Github and others.
Going Serverless. How Firebase and Firebase cloud functions can help you go serverless, and forget all about the messy business of infrastructure configuration and maintenanceA 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 simple to esoteric and obscure
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.Google Cloud Platform. Assorted GCP (Google Cloud Platform) topics and how tos.
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

For the most geeky amongst you, those are the 4 most geeky things i have written about

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.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.
React,Redux,Redis,Material-UI and Firebase. A whole bunch of front end platform libraries that go together really well, but that are hard to grasp and get started with. Here’s a bunch of snippets to help show how all these things interact..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.

Site Content

A quick random preview below- Full site map here

DriverParse

This is the the driver for DB.PARSE described in Database abstraction with google apps script. This uses parse.com – noSQL database for…
Read More

Authentication and access

These articles are abridged from my  book on Office to Apps migration. Going GAS, from VBA to Google Apps Script. Now available directly…
Read More

Blog topics

A quick random preview – Access the blog here

GitHub and VBA integration

If you develop shared code for VBA, you’ve probably got some massive workbooks that contain multiple projects that you wish you could separate, but it’s…
Read More