Code Editor

Pressing the "Code Editor" button on the Automate tab will display the Code Editor task pane.
The My Scripts pane will be displayed showing you a list of any previously recorded scripts.

Menu - (Hamburger Button) Toggles between the Script View window and the My Scripts window.
New Script - Displays the Script View window allowing you to type the script directly.
My Snippets - Displays the My Snippets window displaying a list of your saved snippets.
Samples - Displays the list of code samples.


New Script

Displays the Script View window.

Menu - (Hamburger Button) Toggles between the Script View window and the My Scripts window.
Run - Runs the script on the active workbook.
Save Script - Saves the script to the cloud.
You can click on the name of the script to Rename the script.


Save Script



Share Script

Secure script sharing lets you share your scripts with other users in the same organisation.
Sharing is done on a per workbook basis.
This means that when you share a script you are actually sharing it in the workbook, so everyone who has access to that workbook also has access to view and run the script.


This offers automated control through the Excel namespace.
Office Scripts run to completion after pressing the Run button.
The intellisense in this editor is the sam intellisense used in VS Code.
All code will be recorded in TypeScript (which is a superset of JavaScript).
This is the same editor as VS Code.


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