Office Scripts Preview is available for Excel Online only as of February 21, 2020 – if you have an E3 or E5 License. I’m using Office Pro Plus which is a flavor of an E3 license (not all services that come with E3 license). Office Scripts is using TypeScript which is a superset of Javascript. TypeScript was created by Microsoft in 2012.

Admin Access To Office Scripts

Your administrator can grant access to Office Scripts

Point your browser to admin.microsoft.com. At the username dialog enter the admin username (email address)

At the password prompt, enter the admin password

If the username and password are correct, you are now logged into the Admin Center

Show All

Click on the Show All Tab to reveal additional options

Settings…Settings

Click on Settings chevron to expand the menu. Then click on Settings below Settings (confusing)

Services…Office Scripts

On the Services Menu, scroll down to Office Scripts

Tick the box “Let users automate their tasks in Office on the web” and click on the button “Save changes”

Automate Tab

Go to office.com, login click on the Excel App and click on New blank workbook

Note the new tab above the Ribbon “Automate”

When you click on the Automate Tab you will see the Record Actions (Macro Recorder) and the Code Editor Icons. Here, I clicked on the Code Editor. Quite different from the VBE (Visual Basic Editor).

Microsoft Docs Reference

Good reference material for Office Scripts on Microsoft Docs to get you started.

What Do Office Scripts Mean For VBE (Visual Basic Editor) ?

My best guess is that once Office Scripts is rolled out for the desktop, the development will take place in a different IDE (Integrated Development Environment) such as Visual Studio or Visual Studio Code

What Does It Mean For Python?

Python as a scripting language for Excel (Office) is the #1 upvoted item on Excel User Voice at 6,342 votes as of February 22, 2020. As of February 22, 2020, Python is the #3 programming language in the world, JavaScript is #7 according to the Tiobe Index. Maybe Office Scripts will help to propel JavaScript? Or maybe one day we will see Office Scripts/TypeScript as a separate entry on the Tiobe Index?

Tidy Up

That’s it for today. Post inspired by Bill Jelen’s (aka Mr Excel) Podcast. Make sure you check it out.

, , , , , , ,