Introduction to Office Scripts & How to Tweak Macros to Automate Tasks in Excel

Get started with Office Scripts. Similar to Excel VBA macros, Office Scripts allow users to automate tasks in Excel. The fundamental difference is that VBA macros are developed for desktop solutions and Office Scripts are currently only supported by Excel on the web (and in Excel for Teams).

00:00 Introduction to Office Scripts
00:38 How to Record a Macro in Office Scripts (Record Actions)
04:15 Review the Code in the Code Editor
06:00 How to Run a Macro
06:34 How to Adjust the Script for Dynamic Ranges
08:26 Dynamic Ranges with Office Scripts
09:36 How to Debug Code with Console.Log
11:03 Use Existing Scripts on Different Spreadsheets
12:09 Script Editing Options
13:16 How to Run Office Scripts in Microsoft Teams
13:47 Wrap Up

🚩Let’s connect on social:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#excel #officescripts

[KevinChar]

Hey Leila, I have attended your VBA course for Excel last time. That can't overstate how great your course is. I still use it to this day and I still go back to the course from time to time for what you've taught me.
Yes, I honestly feel the need to have the VBA power on the web. If you are planning to have Office Scripts course, I will definitely be the first student in your class!

[joellen]

Your video is easy to follow and a great jumping off point for me, as I'm new to Excel for web and spent ages trying to figure out how to workaround lack of macro and VBA support. Then I found the magic words 'Office Scripts'. Thank you very much!

[AWFarmer]

New VBA macros have never been so well commented when recording. Office script doesn't look bad.

[chetanbangadi]

Dear Leila,
Good afternoon,
Your teaching style is very simple and easy to understand.

Thanks

[dlep]

I hope that the office script language will be quickly included in Excel Desktop to have the same level of functionalities everywhere.

[ramm]

GREAT Teacher. Kudos. Thank you Leila. I have allways viewed your videos and learned. You make a difference. With Gratitude

[estivisonmc]

Cool! It's future VBA on web office

[hospitaldecisionsupport]

Hi Leila,
Thanks for your nice and easy to understand videos.
I have a relatively simple project that I want to do in office scripts.
Here's the project:
There are 16 files in a folder like 1, 2, 3, 4...16. Each file has 5 worksheets with similar names like a, b, c, d, e.
The task is to summarize all these files. I need to copy cell 'B2", 'B3' and 'C2:F2' from all files' x worksheets and paste those into a file name Summary's worksheet 'summary' cell B1, B2, 'B3:F3' respectively. All copied cells will be pasted one after another in the summary file.
I can run manually without any auto trigger as it is required to do occasionally. The objective is to avoid copy paste manually which is error prone.
How can I achieve this?
Thanks,
Ash

[vijayarjunwadkar]

Nice video to get started on Office Script! You are a great teacher Leila, taking one step by step through the procedure, while explaining it so well! Appreciated and looking forward for more! 😊👍

[arnauddrouin]

Great video thanks a lot ! I have a question : If I already have my formatting, my chart, and other functions on my sheet, and I want to duplicate this formatting onto other sheets in my workbook, do I have to start from scratch by recording my actions? Is there a solution for sheets that have already been created?

[andrewmoss]

It will be really cool when Office Scripts comes to the desktop version. I’d also like the ability to manipulate dropdowns, checkboxes and radio buttons — just like with VBA.

[SimpleExcelVBA]

Really nice & short example of Office Script. Appreciate your work!

[JuanMartinez-icsg]

Great video. I hope you continue this series of videos about Office Scripts.

[pupycron]

This was a great intro I have been wanting to learn this but have been afraid to start. This was a great toe-dip into the water and I'll be all the way into the pool eventually!

[haowang]

Great to know stuff about office scripts! Hope can develop custom functions and share within teams across the web!

[karunatayal]

Hey Leila, I am just new with this script and it helps me to lil bit understand what actaually it is. I felt it is helpful for me, I checked few more tutorials for the same but your tutorial has something, thanks :)

[themen]

Honestly (in my opinion) you became an advertiser more than a teacher.

[ramymahfouz]

Thank you for this fantastic video. it was helpful. This gave me a fair idea about Office script future.
I want to ask if you have prepared a complete course on this so I can buy it.

[FarhanMerchant]

I like this approach, need to test it.

[abughaida]

Thank you very much, I really find your videos very worthy and helpful, really appreciate your efforts in sharing the knowledge.