Execution API and Office to Apps migration


 


These articles are abridged from my book on Office to Apps migration. 

Going GASfrom VBA to Google Apps Script.

Now available  from O'Reilly or Amazon.

What is the Execution API ?

This is a brand new API that enables the running of Apps Script functions from other processes via JSON REST requests, or by using a library specific to your development language. Although it can be run from Apps Script, its main function is to provide access to Apps Script capabilities from other platforms. The libraries and developer tools quickstart can be found here.

There is some similarity to the google.script.run namespace, whose function is to enable add-on/HtmlService communication between client and server.  Although probably not the purpose for which it was envisioned, this API is also a powerful tool to enable incremental migration from Office (or anything else) to Apps by increasingly delegating activities from VBA to be executed by the Execution API in Apps Script, while continuing to orchestrate the process from Office until the migration is complete. 

There is no official Google library for VBA, but these examples use the Execution REST API to create an access class with a simple interface for VBA projects.





Here's how the Execution API can enable VBA to Apps Script migration. There are examples and walkthroughs as well as VBA and Apps Script code samples. 

All code samples can be found on Github. Note that that VBA samples have been developed for Office for Windows and may need some tweaking for Office for Mac.
The gadget spec URL could not be found

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, available All formats are available now from O'Reilly,Amazon and all good bookshops. You can also read a preview on O'Reilly

If you prefer Video style learning I also have two courses available. also published by O'Reilly.
Google Apps Script for Developers and Google Apps Script for Beginners.