To be able to use the Execution API, various assets that are not naturally found in VBA are required. Those of you who are regular visitors to this site may already be using the tools that have been available here for a long time. They are all available on GitHub.
Inventory required for this demo of Execution API use case.
|Execution API||the Google API to execute Apps Script functions remotely.|
|Executable examples||Apps Script examples of functions to be executed remotely.|
|VBA examples||VBA examples of delegating to Apps Script.|
|SheetExec (Apps Script)||A generic Apps Script function which can be used to manipulate Sheets remotely.|
|SheetExec (VBA)||The same thing implemented to access Excel sheets.|
|cExecuteApi||Execution api access class for VBA|
|cOauth2||Google OAuth2 Authentication class for VBA|
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.
- Authentication and access
- Final migration steps
- Incremental migration
- JSON and VBA
- Migrating logic
- Migrating orchestration
- Reading and writing Sheets from VBA
For more like this, see Execution API and Office to Apps migration. Why not join our forum, follow the blog or follow me on twitter to ensure you get updates when they are available.