Office Script as an alternative to VBA

Office Script has been around for a while, the big draw seems to be Online, so Office 365 etc.

I haven't really been following it, but getting up to speed now. See the video below which got my attention a while back 

Big Caveat: on deeper investigation, It only seems to be available for Excel, not Word, which will still be stuck with VBA for the time being, which is a couple of years on from all the excitement, so slightly disappointing there. But something similar has happened with Google Docs, so more on that when I get time to post

https://www.youtube.com/watch?v=DOvHqukAGTY&t=57s

Introduction to Office Scripts:

https://www.youtube.com/watch?v=fny4zUycp_w

Video summary [00:00:00]¹ - [00:14:01]²:

This video introduces Office Scripts, a feature that allows users to automate tasks in Excel Online and Teams using TypeScript. It demonstrates how to record, edit, and run a script that creates a column chart from a data range. It also shows how to make the script dynamic, so that it can work on different data sets and files. The video covers the basics of Office Scripts, such as the code editor, the script gallery, the output window, and the script location.

Highlights:

• [00:00:00]³ The purpose and benefits of Office Scripts
  • Automate boring, repetitive tasks in Excel
  • Work on Excel Online and Teams
  • Replace VBA macros that don’t work on the web
• [00:01:15]⁴ How to record a script using the Automate tab
  • Click on Record Actions
  • Perform the desired actions on the workbook
  • Stop the recording and view the script
• [00:04:04]⁵ How to edit a script using the code editor
  • Rename the script and save it
  • Use the comments to understand the code
  • Make changes to the script, such as adding variables or methods
• [00:06:04]⁶ How to test and run a script on different data sets
  • Click on Run Script
  • View the output and the chart
  • Run the script on other tabs or files
• [00:11:08]⁷ How to manage and share scripts
  • Find the scripts in OneDrive under Documents
  • Use More Options to copy, rename, share, or delete scripts
  • Use Power Automate to automatically run scripts
• [00:13:18]⁸ How to run scripts in Teams
  • Open the file in Teams
  • Go to the Automate tab
  • Select and run the script