3 ms·
GAS is super easy to get (it’s JavaScript), but until you can execute scripts client-side, it won’t ever really take off. It also has the same problem that VBA
by nunez 9y ago
GAS is super easy to get (it’s JavaScript), but until you can execute scripts client-side, it won’t ever really take off.
It also has the same problem that VBA has in that the code resides local to the object consuming it (spreadsheet, doc, etc), so you can’t version control it like you would for a normal application).
VBA even has the advantage of being able to load .NET libraries, which is huge given that you can let the .NET VM do the heavy lifting and use VBA to lay results out onto your sheet or Word doc.