What Are Office Scripts?
Office Scripts is Microsoft's TypeScript-based automation platform for Excel running in Microsoft 365 and Excel for the web. It allows users to record actions in Excel and edit the resulting script, or write scripts from scratch, to automate repetitive tasks. Unlike VBA, Office Scripts run in the cloud and can be triggered from Power Automate workflows, scheduled tasks, or shared across an organisation without the deployment challenges of VBA macros.
How Office Scripts Differ from VBA
- Runs in Excel for the web and Microsoft 365, not just desktop
- Uses TypeScript — a modern, readable programming language
- Can be triggered by Power Automate flows without opening Excel
- Scripts run in the cloud — no local macro security issues
- Easier to share and deploy across an organisation
- Better suited to scheduled and event-driven automation
- More limited UI capability compared to VBA (no custom forms)
- Requires Microsoft 365 Business or Enterprise — not available on basic plans
When to Use Office Scripts Instead of VBA
Office Scripts is the right choice when the business is moving to or already operating in a Microsoft 365 cloud environment, when the automation needs to run without a user opening Excel (triggered by Power Automate), when the script needs to be shared across multiple users without macro security management, or when the task is straightforward data processing that does not require custom user interfaces.
Office Scripts and Power Automate Integration
One of Office Scripts' most powerful capabilities is its native integration with Power Automate. A script can be called as a step in a Power Automate flow — for example, processing a new row added to an Excel table, generating a report when an email arrives, or refreshing and emailing a summary on a daily schedule. This combination extends Excel automation beyond the desktop into the broader Microsoft 365 ecosystem.
Practical Applications for NZ Businesses
- Automated data formatting and cleaning on new file arrival
- Scheduled report generation from SharePoint-hosted workbooks
- Email-triggered data processing workflows
- Multi-step Power Automate flows with Excel processing steps
- Shared team tools that run consistently without VBA deployment
- Integration with Microsoft Teams and SharePoint
Frequently Asked Questions
- Does Office Scripts replace VBA?
- Not entirely. VBA remains more capable for complex desktop applications, custom user forms, and scenarios requiring deep Excel object model access. Office Scripts is better for cloud-first, scheduled, and shared automation scenarios.
- Do I need to know TypeScript to use Office Scripts?
- Basic scripts can be recorded without writing code. More complex automation requires TypeScript knowledge. XLS Experts can develop Office Scripts solutions for organisations moving to cloud Excel environments.
- What Microsoft 365 plan includes Office Scripts?
- Office Scripts is available with Microsoft 365 Business Standard, Business Premium, and Enterprise plans. It is not available on Microsoft 365 Business Basic or personal plans.
Conclusion
Office Scripts represents the future of Excel automation for organisations committed to the Microsoft 365 cloud environment. For New Zealand businesses that want automation to run without desktop dependencies, integrate with Power Automate, and be shared easily across teams, Office Scripts is a powerful and increasingly capable platform. XLS Experts works across VBA, Office Scripts, and Power Automate to recommend and deliver the right automation approach for each business environment.
