Cursusinhoud

Do You Need to SWITCH from Excel VBA Macros to Office Scripts?

For decades Excel VBA Macros has been the best choice for automation topics in Excel. But are Office Scripts there to replace Excel VBA Macros? Is VBA still relevant in 2021? In this video I'll share my thoughts about this topic with you.

★ My Online Excel VBA Course ► https://courses.xelplus.com/p/excel-vba-excel-macros

Office Scripts and VBA macros have a lot in common. They both allow users to automate solutions in Excel. The fundamental difference is that VBA macros are developed for desktop solutions and Office Scripts are designed for secure, cloud-based solutions. At the moment, Office Scripts are only supported in Excel on the web (and in Excel for Teams). The great thing about Office Scripts is that you can use Power Automate to run the script. So you can run your macro without even opening Excel.

★ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/

Timestamps:
00:00 Office Scripts Vs VBA Macros?
00:38 Differences Between VBA and Office Scripts
01:15 How to Use Excel VBA
04:26 How to Use Office Scripts
11:24 Trigger Office Scripts with Power Automate
11:52 Will Office Scripts Replace VBA Macros?
12:27 Wrap Up

LINKS to related videos:
► Introduction to Office Scripts: https://youtu.be/fny4zUycp_w
► Learn Macros in 10 Minutes: https://youtu.be/An-2Nxf_Dms

Complete blog post: https://www.xelplus.com/excel-vba-vs-office-scripts

✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

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!

#MsExcel #ExcelVBA #officescript

Beoordeling
0 0

Er zijn momenteel geen reacties.

om als eerste een reactie achter te laten.