The definitive resource for Google Apps Script and Microsoft Office automation
I am a Google Developer Expert and give my time to [cdsfjsghghieg]
You want to learn Google Apps Script?
Learning Apps Script, (and transitioning from VBA) are covered comprehensively in my my book, Going Gas – from VBA to Apps script & Videos if you prefer video style learning.
Here is how to support this site:
If you find the material here useful, why not help to support it by buying my Google Apps Script and VBA Titles published by O’Reilly media
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.|
|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.|
4 most visited things
|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
|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.|