Morioh
Login
Anahi Kirlin

Anahi Kirlin

3 years ago

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.

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.

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

#excel

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

youtube.com

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.

4.20 GEEK