As the migration progresses, there is less and less happening in VBA, and its role is reduced to one of orchestration. In this example, all the data has moved to Sheets along with the logic. VBA still orchestrates the process, and potentially makes some other changes, or updates based on the logic result that are outside the scope of the process being migrated.
|
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.
- Final migration steps - In most cases the Office workflow can be retired. However there are cases when legacy dependencies still need to be maintained for some period.
- Testing Javascript on the PC - you can even use the Execution API to retrieve Apps code to execute locally on the PC. A great tool for early testing of migrated code.
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.
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.
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.