VBA x GAS

Google検索「gas excel vba 連携」

Excel VBAとGoogle Apps Scriptの構文比較

これは凄く便利だった

てじらぼ　https://www.teijitaisya.com/gas-vba-spreadsheet/

Google が仕掛ける「Google Apps Execution API」という野望

Bruce McPherson, a Google Developer Expert (GDE) for Google Apps, says: “The Execution API is a great tool for enabling what I call ‘incremental transition’ from Microsoft Office (and VBA) to Apps (and Apps Script). A mature Office workflow may involve a number of processes currently orchestrated by VBA, with data in various formats and locations. It can be a challenge to move an entire workload in one step, especially an automated process with many moving parts. This new capability enables the migration of data and process in manageable chunks.” 

https://cloud.google.com/blog/products/workspace/run-apps-script-code-anywhere-using-execution-api

これについて触れている日本語のブログ

VBAマクロからGoogle Apps Script Execution APIを呼び出す。