Automate Tab

Once Office Scripts has been enabled by your administrator you will see an additional tab called "Automate".

Record Actions - Displays the Record Actions task pane.
As soon as you press this button the recording will start.
Every time you edit a cell or perform an action the recorded steps are listed in the task pane.
When you have finished your actions press the Stop button.
All the actions will be recorded and translated into a script.

Code Editor - Displays the Code Editor task pane.

The actual code that is generated is TypeScript (which is a superset of JavaScript)

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext