Going GAS: From VBA to Google Apps Script
Bruce Mcpherson, "Going GAS: From VBA to Google Apps Script"
English | ISBN: 1491940468 | 2016 | PDF/EPUB/MOBI | 456 pages | 9 MB/7 MB/19 MB
English | ISBN: 1491940468 | 2016 | PDF/EPUB/MOBI | 456 pages | 9 MB/7 MB/19 MB
If you’re making or investigating the transition from Microsoft Office to Google Docs, or simply trying to get started with Google automation and APIs, this practical book covers each of the major services accessible from Google Apps Script, including add-ons and integration with external services.
With a particular emphasis on how to transition from Microsoft’s Visual Basic for Applications (VBA) to Apps Script, all the common VBA functions are rewritten in JavaScript with equivalence tables for how to do it in Apps Script.
This book provides a unique transitional library of VBA built-in functions, written in Apps Script but with the same names and arguments as VBA—that means you need to make only minimal changes to VBA code when "going GAS."
Learn how to go from VBA to Apps Script
Get a side-by-side comparison of Apps Script services vs Microsoft add-ins
Access and integrate with external data from Apps Script