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.
|
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 maintenance
|
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 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.
|
Ephemeral Exchange. The easy way to exchange data between reluctant platforms.
|
| 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
|
Google Cloud Platform. Assorted GCP (Google Cloud Platform) topics and how tos.
|
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
|
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.
|
|
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.
|
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.
|
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.
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.