No More VBA. ChatGPT to automates boring work with Office Scripts

Excel Office Scripts are the future of automation for Excel and other Office apps, replacing VBA and macros going forward. In this video I use ChatGPT to write an Office Script for me and the results are impressive!

⬇️DOWNLOAD the example file & Office Script here: https://myonlinetraininghub.com/write...

📜OFFICE SCRIPTS LICENSING REQUIREMENTS
Office Scripts is available to Excel users with the following:

1. Excel for Windows (version 2210 or higher), Excel for Mac, or Excel on the web.

2. OneDrive for Business.

3. Any commercial or educational Microsoft 365 license with access to the Microsoft 365 Office desktop apps, such as:
• Office 365 Business or Business Premium
• Office 365 ProPlus or ProPlus for Devices
• Office 365 Enterprise E3 or E5
• Office 365 A3 or A5

4. Internet connectivity with connected experiences enabled.

🎓 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

📢 Please leave me a COMMENT. I read them all!

🎯 CONNECT with me on LinkedIn:   / myndatreacy  

🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...


⏲ TIMESTAMPS
0:00 What are Office Scripts
0:52 Where to find Excel Script Tools
1:24 The Scenario
1:49 Using ChatGPT to write Office Scripts
3:07 Using the Script form ChatGPT
3:42 Running the Script
4:08 Handling Errors in ChatGPT Scripts
4:38 Re-using Scripts you Create
5:04 Assigning the Script to a Button