These articles are abridged from my book on Office to Apps migration. Going GAS, from VBA to Google Apps Script. Now available for directly from O’Reilly or Amazon.
Now the data has been migrated, the logic migrated and the orchestration is now managed by Apps Script. In most circumstances, the job is done, but there may be some circumstances (legacy databases and systems automation for example), where automation needs to remain on VBA for some time.
Other items in this section
- Incremental migration – the steps involved in moving workload from Office to Apps in manageable chunks.
- VBA and Apps Script inventory – what’s needed, and examples of orchestrating the Execution API from VBA.
- Authentication and access – how to authenticate to and access the Execution API from VBA.
- JSON and VBA – how to deal with JSON and navigate JavaScript like objects in VBA.
- Reading and writing Sheets from VBA – manipulate sheet data directly from VBA.
- Migrating logic – delegating logic tasks to Apps Script from VBA.
- Migrating orchestration – the migration is almost complete. Move the orchestration tasks to Apps Script.
For more like this, see Execution API and office to Apps migration.
Going GAS subpages