Going GAS: From VBA to Google Apps Script (1)

By: Bruce Mcpherson

Sign Up Now! Already a Member? Log In
You must be logged into Bookshare to access this title. Learn about membership options, or view our freely available titles.

Synopsis: Whether you’re moving from Microsoft Office to Google Docs or simply want to learn how to automate Docs with Google Apps Script, this practical guide shows you by example how to work with each of the major Apps Script services.Office still supports VBA, but it’s not likely to do so for much longer. If you’re a VBA or .NET developer, you’ll learn how to port existing VBA code and structure to their JavaScript-based Apps Script equivalents with minimal effort. Author Bruce Mcpherson introduces JavaScript basics for experienced developers unfamiliar with the language, and demonstrates ways to build real-world apps using all of the Apps Script services previously covered.Use App Script’s equivalent of Excel’s object modelTarget the most commonly used parts of Microsoft WordAutomate processes in Gmail, Calendar, and ContactsAccess the local client filesystem with Google DriveBuild and run applications in a browserStore persistent data convenientlyRender HTML content in response to HTTP requestsAutomate the maintenance and creation of pages and contentInteract with a REST service or NoSQL databaseAccess Apps Script capabilities from other platforms