Photographer Guide· a Bicycle Guide

Partial profile · Book Profile — full narrative profile planned

Going GAS From VBA to Google Apps Script

A practical guide for VBA developers to successfully transition their skills and applications from Microsoft Office to the Google Apps Script platform, complete with a VBA emulation library to accelerate the migration process.

A profile of this book is on the way.

Get the book →

What it’s about

For years, you've built essential business processes using VBA in Microsoft Office, but now face an uncertain future as VBA ages and Microsoft's focus shifts to the cloud. 'Going GAS' is your definitive guide to migrating that valuable investment to Google Apps Script, a modern, cloud-native platform. This book doesn't just teach you a new language; it translates your existing expertise. Through direct comparisons, practical examples, and a unique VBA-to-JavaScript emulation library, you'll learn to 'copy/paste port' your legacy code with minimal changes, master Google-specific services like Sheets, Docs, and Gmail, and adopt best practices for performance and security in a cloud environment. Future-proof your skills and applications by making a smooth, efficient transition from the desktop to the cloud.

The through-line

Who it’s for
A skilled VBA developer who has invested years creating valuable, custom automation for business processes within Microsoft Office. They want to modernize their applications, move to a collaborative cloud platform like Google Workspace, and future-proof their skills, but are concerned about the daunting task of rewriting their extensive VBA codebase.
The problem
The VBA applications they depend on are becoming fragile, difficult to maintain across different Office versions and operating systems, and face an uncertain future as Microsoft pivots to cloud-first platforms like Office 365. They feel anxious and overwhelmed by the prospect of migrating their complex applications, fearing a steep learning curve, a massive loss of their invested time and effort, and the potential obsolescence of their hard-earned skills.
The plan
  1. Learn the core differences and parallels between the VBA and Google Apps Script languages and environments.
  2. Utilize the provided VBA-to-JavaScript emulation library to quickly port existing code with minimal changes.
  3. Master the Google Apps Script services that correspond to the Office object models you already know (e.g., SpreadsheetApp for Excel).
  4. Adapt your coding style to the cloud by learning best practices for performance and quota management.
  5. Build modern user interfaces and integrations using the HTML Service and external APIs.
The payoff
Successfully migrated, modernized, and future-proofed business-critical applications on a stable, cloud-native platform. · Gained proficiency in JavaScript and the Google Workspace platform, making your skills highly relevant and valuable. · Enabled new levels of collaboration and accessibility for your automated workflows, freeing them from the constraints of the desktop.

See our guide

Related profiles we’ve built

Additional reading

PrivacyTermsSupport