Books & Videos

Table of Contents

  1. Chapter 1 Introduction

    1. What Is VBA?

    2. What Is JavaScript?

    3. What Is Apps Script?

    4. What Are Google Add-Ons?

    5. What Are Google Forms?

    6. What Are Microsoft Add-Ins?

    7. Comparison

  2. Chapter 2 Language Basics

    1. Style

    2. Operators

    3. Variables

    4. Functions

    5. Layout

    6. Scope

    7. Objects

    8. Classes

    9. Namespaces

    10. The IDE

    11. Libraries

  3. Chapter 3 Translating VBA Functions

    1. Conventions

    2. Library and Namespace

    3. JSDOC

    4. VBA Built-Ins Translated to JavaScript

    5. Handling Errors

    6. VBA Built-In Objects

  4. Chapter 4 Living with the Quotas

    1. The Quotas

    2. Throttling

    3. Avoiding Service Calls

  5. Chapter 5 The Properties Service

    1. APIs Versus Built-In Services

    2. Getting Started with Properties Service

    3. Uses and Types of Property Stores

    4. Selecting a Property Store

    5. The Registry Versus the Property Store

  6. Chapter 6 The Spreadsheet Service

    1. Custom Formulas

    2. Container-Bound Versus Standalone Scripts

    3. Getting Started with the Spreadsheet Service

    4. The Range Class

    5. Inserting and Deleting Rows and Columns

    6. Opening Other Sheets

    7. Opening Other Workbooks

    8. Showing Messages

    9. Getting and Setting Properties

    10. Custom Formulas

    11. Adding Functions to Menus

    12. Tables

  7. Chapter 7 The Document App

    1. Opening Documents

    2. Working with Elements

    3. Traversing the Document

    4. Ranges

    5. Named Ranges

    6. Position

    7. Bookmarks

    8. Editing Text in Elements

    9. Adding Elements

    10. Inserting Elements

    11. Tables

    12. List Items

    13. Images

    14. Docs Automation Example

    15. Attributes

  8. Chapter 8 Gmail, Calendar, and Contacts Apps

    1. Email Automation Exercise

    2. Threads

    3. Messages

    4. Recipients

    5. Labels

    6. Calendar

    7. Contacts

    8. Setting Up the Example

    9. Triggers

  9. Chapter 9 Drive and DriveApp

    1. Microsoft OneDrive

    2. Reading and Writing Files

  10. Chapter 10 HTML Service

    1. Why Client Execution?

    2. HTML Service Varieties

    3. jQuery

    4. Event Handling

    5. Templates

    6. Controlling Apps Script from the Client

    7. Dialog HtmlService

    8. HtmlService Web Apps

    9. VBA User Form

  11. Chapter 11 Content Service

    1. The Content Service

    2. Where to Use the Content Service

    3. Types of Content

    4. Example

    5. JSONP

    6. XML

    7. Publishing

    8. Delegation from VBA

  12. Chapter 12 Charts

    1. Chart Data

    2. VBA Charts

    3. Sheets Charts

    4. EmbeddedChartBuilder

    5. Visualization API

    6. Other Chart Formats

  13. Chapter 13 Sites

    1. Apps Script

    2. Gadgets

    3. Code Lockdown

    4. Advertising

    5. VBA

    6. The Future of Sites

  14. Chapter 14 Advanced Google Services

    1. What Are Advanced Google Services?

    2. Advanced Services Versus Google APIs

    3. Developers Console

    4. Fusion Tables Example

    5. Scripts Structure

    6. Currently Available Advanced Services

  15. Chapter 15 Authentication and Security

    1. OAuth 2.0

    2. Scopes

    3. Listing Authorized Apps

    4. Revoking Access

    5. ScriptApp

    6. Service Accounts

    7. Libraries

    8. OAuth 2.0 Example

    9. Accessing Other Oauth 2.0 Services

    10. OAuth 2.0 with VBA

    11. Other Kinds of Authentication

    12. JWT (JSON Web Tokens)

    13. Firebase Authentication

    14. Standardized OAuth 2.0 Process

  16. Chapter 16 External APIs and Integration

    1. REST API

    2. Databases

    3. Firebase

    4. Databases and Apps Script

  17. Chapter 17 Execution API

    1. What Is Incremental Migration?

    2. Migration Process

    3. The Execution API

    4. Inventory for Execution API

    5. Authentication and Access

    6. JSON

    7. SheetExec

    8. Example Workflow Migration from Office

    9. Moving a Workbook to Sheets

    10. Migrating Logic

    11. VBA Orchestration

    12. Final Migration Steps

    13. Testing JavaScript on the PC

    14. Execution API Potential

  18. Chapter 18 Office Add-Ins and Google Add-Ons

    1. Add-Ons

    2. Add-Ins

    3. The Same...

    4. ...But Different

    5. Add-On Example

    6. Apps Script Add-On

    7. Testing an Add-On

    8. Office Add-In

    9. Testing the Add-In

    10. Result Comparison

    11. Further Exercises

  19. Appendix Further Resources

    1. GitHub Repository

    2. Other Resources

    3. Keys and Credentials