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


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).



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