What are Office Scripts? Office Scripts in Excel let you automate tasks. You can create and edit scripts with the Code Editor. You can run a series of Excel steps with a single button. Then, share that script with coworkers so everyone can improve their workflow.

You can get more information at Microsoft on the web. The article is called Office Scripts in Excel. If you have some repetitive tasks in Excel that you would like to automate so that it only takes a button click or two to accomplish, Office Scripts may be worth learning.

What do you need to use Office Scripts? Excel for Windows, for Mac, or on the web. OneDrive for Business. Any commercial or educational Microsoft 365 license with access to the Microsoft 365 Office desktop apps, such as: Office 365 Business, Office 365 Business Premium, Office 365 ProPlus, Office 365 ProPlus for Devices, Office 365 Enterprise E3, Office 365 Enterprise E5, Office 365 A3, or Office 365 A5. If you meet these requirements and are still not seeing the Automate tab, it’s possible that your admin has disabled the feature or there’s some other problem with your environment.

Comparing VBA to Office Scripts

You probably know that you can automate tasks in Excel with Visual Basic for Applications (VBA). You can use a macro recorder to have some code written for you and you can choose to write the code yourself in the Visual Basic Editor (Alt+F11). Both VBA and Office Scripts are used to automate tasks. Both are targeted toward the business user and the programmer. VBA is for the Desktop and not for the Web. Office Scripts is for the Web and is not yet available for the Desktop. Office Scripts is for Excel online or Excel files you use in Microsoft Teams.

Learn with YouTube

Here is a YouTube video on