Automating Excel tasks to come to Windows and Mac
Users running Excel on either Windows or Mac PCs will soon be able to automate many of the now-manual tasks in their spreadsheet software, something that currently is only available to those using the web application., starting in October, users will be able create, edit, and run Office Scripts to automate these tasks using the Code Editor and All Scripts taskplane.
Users can record what they've done with Action Recorder, which creates a TypeScript language script that can be run again whenever it's needed. Scripts created and edited with the Code Editor can then be shared across the organization, enabling coworkers to automate their workflows, according to a Microsoft online"Scripts allow you to record and replay your Excel actions on different workbooks and worksheets," according to Microsoft.
This summer, Microsoft introduced the idea of bringing Excel into the Teams universe, part of a larger strategy to add functions to Teams to enable greater collaboration in the wake of the COVID-19 pandemic pushing most workers out of the office for more than a year and into their homes or other remote sites.