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)


Every script runs the code in a single main method.
You cannot undo the effect of an Office Script.
The version history of the file should be used as an alternative.
You can turn on the logging console by pressing the Ellipses button and select Logs.



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