An Office Script is the new way to automate boring tasks in Excel. You can run these scripts on the web, in Microsoft Teams and even on your desktop. Now you can help your colleagues find and run your Office Scripts by adding a cool button to your workbooks.
In this Video:
Introduction to Office Scripts & How to Tweak Macros
https://www.youtube.com/watch?v=fny4zUycp_w&t=0s
Office Scripts in Excel let you automate your day-to-day tasks. Inside Excel on the web, you can record your actions with the Action Recorder. This creates a TypeScript language script that can be run again any time.
https://docs.microsoft.com/en-us/office/dev/scripts/overview/excel
Scripts allow you to record and replay your Excel actions on different workbooks and worksheets. If you find yourself doing the same things over and over again, you can turn all that work into an easy-to-run Office Script.
https://docs.microsoft.com/en-us/office/dev/scripts/overview/excel
In this step-by-step tutorial, learn how you can use Office Scripts in Excel on the web to automate repetitive and mundane tasks. Additionally, learn how you can trigger you scripts automatically using Power Automate. With Power Automate, you can set a Teams message, an email, or other app to trigger your script.