Going GAS: From VBA to Google Apps Script

Name: Going GAS: From VBA to Google Apps Script
Rating: 3.5 (2 reviews)

Bruce Mcpherson

Feb 2016 · "O'Reilly Media, Inc."

3.5

2 reviews

Ebook

456

Pages

Eligible

About this ebook

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 model
Target the most commonly used parts of Microsoft Word
Automate processes in Gmail, Calendar, and Contacts
Access the local client filesystem with Google Drive
Build and run applications in a browser
Store persistent data conveniently
Render HTML content in response to HTTP requests
Automate the maintenance and creation of pages and content
Interact with a REST service or NoSQL database
Access Apps Script capabilities from other platforms

Ratings and reviews

3.5

2 reviews

About the author

Bruce is a veteran IT practitioner with 30+ years as CIO, Chief Architect, and many other roles—mainly in large global enterprises such as Motorola and Lucent. With expertise in each of Google, Microsoft and Oracle technologies, his main interest is in integration. For a number of years he has been running a range of popular sites and blogs providing advice and assistance on transition connectivity. Bruce is a GDE (Google developer expert) specializing in Apps Script.

Rate this ebook

Tell us what you think.

Reading information

Smartphones and tablets

Install the Google Play Books app for Android and iPad/iPhone. It syncs automatically with your account and allows you to read online or offline wherever you are.

Laptops and computers

You can listen to audiobooks purchased on Google Play using your computer's web browser.

eReaders and other devices

To read on e-ink devices like Kobo eReaders, you'll need to download a file and transfer it to your device. Follow the detailed Help Center instructions to transfer the files to supported eReaders.