35 - Office Scripts - Beginner's Level - Jan Karel Pieterse

In this session Jan Karel shows you how to enable Office scripts and demonstrates recording a script and writing and debugging one. Session subjects are:
• Getting started with Office Scripts
• Recording your first script
• How are scripts organized (where are they kept)
• Writing from scratch
• Performance improvements
• Debugging
• Sharing a script

[@mmbcampus]

This is Awesome... Nice, simple, clean, can understand easily....

[@MitchTorres]

hi SumProduct- this is great! :) can you help share how to create a script that will copy an existing Worksheet to a new Worksheet with a worksheet name Jul 2022. thanks

[@ignaciogarcia2038]

Can use this approach with hidden sheets? I don't want to use VBA!

[@mmbcampus]

Sir, Can we create dropdown comboBox of all sheets name in ribbon as you did in earlier with VBA?

[@hilalm.397]

Can I use this fuction if I have a personal office 365 plan? or do I need to be part of an enterprise plan?

[@rosgori]

You cannot use Office Script with your personal Office 365 plan.