Our company is moving toward a browser-based workflow, but all my automation is stuck in .xlsm files with VBA. I know Office Scripts uses TypeScript. How difficult is it to convert a basic data-entry macro to an Office Script, and can these scripts be triggered by Power Automate?
3 answers
The transition is a shift from desktop-centric logic to web-centric APIs. VBA interacts with the local application, while Office Scripts (TypeScript) interacts with the workbook object via the web. The "Action Recorder" in Excel on the Web is a great place to start; it generates the code for you as you perform tasks. The real power is the integration with Power Automate. You can set a trigger—like receiving an email with an attachment—and have Power Automate pass that data to an Office Script to process it in the background without ever opening Excel. It’s much more scalable than old-school macros.
Are you worried about the security permissions? Unlike VBA, which can be blocked by IT due to "Macro" security risks, Office Scripts are managed at the tenant level, making them much easier to deploy across a large organization.
Start learning basic JavaScript/TypeScript syntax. Understanding loops and variables in a modern language will make you a much more valuable "Digital" Business Analyst in the current job market.
Great advice, Karen. Moving away from VBA felt scary at first, but TypeScript is so much more versatile for everything else I do in web development now.
Mark, security is actually my main concern. If I share a script, can other users see the source code, or can I "lock" it like a VBA project with a password to prevent people from breaking the logic?