It has been quite some time now a lot of talk around the future of VBA. Here comes the Office Scripts in Microsoft Office web apps like Excel (in its preview) with two important features to seed the beginnings of the end of VBA era:
- Actions recorder: Mimicking VBA macro recorder functionality
- Automation scripting: Mimicking VBA scripting
Office Scripts is based on below technological features:
- Asynchronous Programming Model: The popular roots of asynchronous programming can be traced to AJAX. When we talk about processing on the web, it has to be either light-weight or asynchronous owing to the constraining factors like limited network bandwidth, computing resources, etc., This is more relevant to Microsoft Office web apps like Excel, Word, PowerPoint, etc., Hence, for Office Scripts, Microsoft decides to let run the office automation scripts and the office web app in two different processes and let the communication between these two processes happen asynchronously. Technically, the choice makes absolute sense.
Stay tuned for more learning on Office Scripts..!! Happy Learning..!!