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.
If this is the case, careful attention should be given to quotas and timeouts. In other words if the processes running on Apps Script become too long running, or their results take too long to come back, they may need to be split into smaller chunks.
In any case, any incremental migration project needs as much planning and preparation as a straight cutover and should not be considered as the final operating model.
Another finishing touch you might want to consider is to migrate the color scheme for fonts and background colors from the excel scheme to the Apps scheme. For how to find the closest color in a scheme, see Color Schemes and palettes
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.
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