MicrosoftMrAnalytics , RobEric365 , The question of Office Scripts vs. Office 365 consumer licenses is asked/answered upthread. Right now it seems it's "no plan". And, to the extent that Office Scripts is hopelessly entwined in corporate-IT-speak stuff like Office tenants and scripts only being able to exist on OneDrive, I say good riddance.
I was just revisiting this, after reading RobEric's post, and stumbled on this two-year-old but still seems highly relevant reddit thread: https://www.reddit.com/r/excel/comments/d35025/alternatives_to_vba/. VBA is still very much relevant, for reasons described well in that thread.
I understand, I guess, why Microsoft doesn't want to wholesale refactor VBA for the 21st century and all the environments Excel now runs in. What I can't understand is why they seem to have completely abandoned it in terms of even minor improvements and bug fixes, despite its popularity and many unique advantages for what it is and does, nor why none of the "alternatives" they've tinkered with seem to make much effort to meet the same requirements VBA uniquely satisfies, namely universal availability (at least on Windows and, kinda, sorta, on the Mac--many of my VBA tools fail on Mac because of missing references, primarily Windows Scripting Runtime to get modern things standard in newer languages like Dictionary and FileSystemObject), and integration/user friendliness/user accessibility with Excel and the Excel UI OOB. A "Hello World" example of Excel+VBA is still vastly simpler in VBA than in any of the other alternatives and can be completed by ANY Excel desktop user in a matter of minutes and without leaving Excel. (Assuming their corporate IT hasn't maimed access to VBA.) NONE of the alternatives come close. Edit to add: that five minute "Hello World" can be a UDF, code behind a control like a button, event code (Workbook, Worksheet, etc) or whatever. It can even be a macro recording. What of the VBA alternatives comes remotely close?
VBA helped make Excel ubiquitous. The requirements it satisfies aren't going away. Too bad Microsoft hates it so.
