How can I start writing scripts

Introduction to Office Scripts in Excel

Automate your repetitive Office script tasks in Excel Web. Record your actions and then repeat them whenever you want. You can also edit your scripts if your workflow changes. Office scripts are stored in the cloud so you can update any of your workbooks as needed.

When you record your actions with the action recorder, a script is created. These actions can include entering text or numbers, clicking cells or commands on the ribbon or menus, formatting cells, rows, or columns, formatting data in Excel tables, and other actions. What you see when you're done is a clean task pane that shows a descriptive list of all the steps you've just completed. You don't need coding experience to record and run Office scripts. If you want to edit your actions, you can do so using the code editor, which lets you edit the TypeScript code of the script. Learn all about writing scripts with the code editor in Recording, Editing, and Creating Office Scripts in Excel on the web.

  • An active Microsoft 365 subscription account with a Microsoft 365 commercial or educational license that has access to the Microsoft 365 Office apps. This includes the following:

    • Microsoft 365 Apps for Business

    • Microsoft 365 Business Standard

    • Microsoft 365 Apps for Enterprise

    • Office 365 ProPlus for devices

    • Office 365 Enterprise E3

    • Office 365 Enterprise E5

    • Office 365 A3

    • Office 365 A5

  • OneDrive for Business.

  • Server Authentication - The first time you run Script Recording or the Code Editor, you will need to authenticate with the server so that your scripts can be stored in the cloud. Sign in to your Microsoft account as you normally would, and when you see Permissions requested, select Accept off to continue.

    Note: After you have toggled the correct setting on / off in the admin center, end users with the appropriate license can access the feature. This feature is not yet available in Microsoft 365 US Government and customers with data storage in one of the new geos of the local data center.

First steps

  1. First select im Ribbon the Automate tab. This will be your two primary options in the group Scripting tools made available: Record Actions (Record actions) and news Script (New Script).

  2. To create a new script for Office, press the Record button Actions, and then start the steps you want to automate. In this example, we'll take a simple range of data, convert it to an Excel spreadsheet, add a column and a totals row, and end up formatting our values ​​as currency.

  3. When you start recording an Office script, a Record Actions task pane opens on the right. Here is a brief description of the actions you will take in the order presented. When you have done all the steps, you can click the button break up to press.

  4. After you click the Exit button pressed will have Code editor area with the new script selected.

  5. By default, Excel scripts will be named "Script 1", "Script 2" and so on. However, you should give your scripts meaningful names. Otherwise, you'll need to go through each of the -Ns to find the one you're looking for. To give your script a new name, click the three dots and choose Rename from the pop-up menu.

Play an Office script

  1. If the catalog of Office scripts is not already displayed, you can find it under Automate> Show script tools.

  2. Click the script that you want to run. She will be in Code editor displayed. click on the button Run to start the script. You will see a brief notification that the script is running and will not appear when the script finishes.

    Note: This topic does not cover editing or writing your own TypeScript code, but you can refer to the Office Scripts technical documentation.

  3. More options - If you click the ellipses (...) on the right side of the code editor area, the context menu appears. Here is your option:

    • Rename of the script

    • Making a copy of the script

    • share of the script

    • Automate the script using Flow

    • Delete the Scripts

Potential bugs

  • It is important to understand that when you record a script, Office Script Recording captures almost every assisted action that you take. So if you make a mistake in the sequence, e.g. For example, if you click a button that you did not want to click, the script recorder will record it. The resolution is to re-record the entire sequence or change the TypeScript code itself. Therefore, you should always record a process that you are very familiar with. If you record a sequence more smoothly, it will play back more efficiently.

  • Certain actions might be fine the first time the script was recorded, but fail when played back. In the earlier example where we formatted some sample data as a table, the code would fail if we tried to use it in the updated table because Excel doesn't allow overlapping tables. At this point the code editor displays an error message.

    If you on the Protocols button If you click Show, a brief description of the error is displayed at the bottom of the code editor area.

  • Unsupported features - We're always working on adding support for more features, but not everything is supported right now. In this case, a note will appear in the Record Actions area. You can replay the code and it will just ignore any steps that could not be recorded.

Do you need more help?

You can always ask an expert in the Excel Tech Community or get support in the Answers Community.

See also

Office technical documentation for scripts

Record, edit and create Office scripts in Excel on the web

Troubleshoot Office Scripts

Sample scripts for Office scripts in Excel on the web