A short excerpt from a YouTube video (creator: Paul Barnhurst) arguing that Office Scripts is the future replacement for VBA in Excel. The speaker notes VBA's historical ability to access Windows (now undesirable), suggests Microsoft is investing in Office Scripts, and asserts Python shares many similarities with VBA and was effectively designed to replace VBA in many contexts.
Microsoft has released Office Scripts. VBA gave you a lot more like, exterior access to Windows, which is a bad thing today, but was a good thing back then. So Office Scripts is what I would say is the future. I think that they're starting to put a lot of energy behind that, so I think that is what could replace it today. VBA and Python have a lot in common, so I think people don't realize that because they think of Python as being an advanced language. But Python was really written as the VBA replacement for so many things, not just for this, because Python does it all, and it's just built in a way that combines some of the best features of other languages.
Trust and Leadership Lessons for FP&A From 100+ Top Leaders with CFO Jon Laudie
