A.I., VBA, Office Scripts - The future of Excel

In this podcast our two hosts discuss the highlights of the ongoing development of Excel Online, Office Scripts, VBA and the future of Excel, suggesting a shift towards cloud-based solutions for data management and automation.They provide a comparison between Office Scripts and VBA (Visual Basic for Applications) in the context of automating tasks in Microsoft Excel. Office Scripts, which operate online, are more akin to Azure Functions than VBA, which is an older, offline macro language. While VBA is still useful, Office Scripts offer modern, cloud-based automation capabilities. Power Automate can complement Office Scripts by capturing events and triggering actions, even from external applications like SAP. Office Scripts can run alongside VBA in Excel Desktop, expanding automation possibilities. The podcast highlights the ongoing development of Excel Online, Office Scripts and AI, suggesting a shift towards cloud-based solutions for data management and automation.