Introduced in 1993, Excel VBA revolutionized the utilization of Excel and other Office products, leaving an indelible impact for decades. From crafting basic scripts to orchestrating intricate analytics, and even simulating motor control within the confines of Excel, VBA emerged as a game-changer. This facilitative language empowered developers and users alike to automate tasks with remarkable ease.
Microsoft disabling Macros
Since January 10, 2023 Microsoft has rolled out it change to all Tenants regarding blocking Macros from the Internet. This means that Files with Macros (VB Code) will be blocked if they come from an untrusted Source. But why?
Security
VBA operates the same as Excel. This means VBA has full access to the desktop. Additionally VBA allows JavaScript Auth Tokens and other API capabilities for external Services.
There exist VB Code which shows how to gather data if a user allows the Macro.
Example Option:
One could potentially scan the file explorer for intriguing files and extract their content. With an open connection to an external service, the scope widens, enabling not only data transfer but also potentially facilitating software installation and device control.
Our tip
Microsoft is doing much to secure Users from unknown Macros but in the end, they allow users the execution. Enterprises should consider deactivate the Execution from Macros via GPO to secure their Environment.
Alternatives
When it comes to the limitations of VBA, Office Scripts step into the spotlight as a novel solution. Designed exclusively for online execution within Excel, they come with a distinct set of attributes. Notably, Office Scripts restrict external service connections and operate solely within the context of the workbook, refraining from accessing user or device contexts.
Yet, do Office Scripts encompass the entire scope of VBA capabilities? Not quite, and for good reason. A compelling advantage, however, is their integration with Power Automate. This synergy reshapes the narrative, unlocking a realm of possibilities and more. From PowerApps and Power Automate to Virtual Agents and Power Pages, Office Scripts weave a comprehensive tapestry of control and utility.
As we navigate the landscape of 2023, the role of Excel is evolving. No longer confined to a mere data repository, it morphs into an interactive conduit, amplified by these dynamic services. Embrace this transformation – digitize Excel sheets, or explore alternatives within the PowerPlatform, and chart a course towards a future where efficiency and innovation coalesce.
Settings for Office Script
Admins are capable to restrict the Usage of Office Scripts. They either can allow or disable it for the whole tenant or they could only allow it for a specific group. They also can decide who can share or use any Office Scripts.
