Getting Started

It is possible to record your actions and to create other scripts of your own using the Automate Tab.
The Record Actions is a very useful tool that can be used to generate the code for you.
The code that is generated is TypeScript which is a superset of JavaScript.
This tool is extremely helpful regardless of how much programming experience you have.

At the moment the Automate tab is only available in Excel.
There is no Automate tab in Word, PowerPoint or Outlook because these applications do not support Office Scripts.
Office Scripts was specifically designed for Excel and is not tightly coupled to the workbook and worksheet object models.
Its time to stop doing the same thing over and over again and start creating scripts that you can run using a button.

The Code Editor

This can be used to create new scripts and edit existing ones.
It also allows you to add additional code such as performing conditional statements or loops.
Every script runs the code in a single main method.

The Action Recorder

All the actions that you make for example, editing cells, applying formatting, creating charts etc are converted to a script.
To start recording select (New Script > Create from Recording)

Pressing a Button on the Worksheet

Buttons can be added to worksheets to let users quickly run scripts without having to use the Automate tab. more info

Adding Shortcut Keys

It is not possible to add a shortcut key to run a script at the moment.

Sharing your Scripts

You can quickly share scripts across workbooks and with coworkers.

Power Automate

This is to automate and streamline entire workflows.

More Information

If you have any questions or need any help, please get in touch with us.