Re:Products I Wish Existed
by gkfasdfasdf on Tuesday January 07, 2020 @09:09AM
(#21980005)
> No VBA
FWIW Google Sheets does have the ability to write macros in JavaScript. They even have an npm tool [0] that will let you edit offline via your preferred IDE and then push to your sheet.
Re:Products I Wish Existed
by reportgunner on Wednesday January 08, 2020 @03:48AM
(#21989629)
I'm not saying JS is better or VBA, but JS is definitely not VBA.
Re:Products I Wish Existed
by twojacobtwo on Thursday January 09, 2020 @12:18PM
(#22003165)
Gsuite uses 'Apps Script'[1], not pure JS, so it is quite similar in function to VBA.
No VBA, no keyboard shortcuts, (no cross-workbook references).
Imho two people working inside the same worksheet at the same time was never an Excel's missing feature.