Enjoy the Benefits of Scripts and Power Automation.
Excel Automation without VBA Macros is now possible. You can now use Office Scripts and Power Automate instead of Excel VBA macros to automate repetitive tasks. You can also use Power Automate to schedule these tasks to take place at times that your organsiation requires.
One of the downsides of Excel VBA macros is that a few bad actors use VBA for malicious purposes. This then requires the IT Section to spend valuable time and resources to implement robust policies to block VBA Macros.
The new Excel Automation through Office Scripts and Power Automate can be performed on non macro Excel files which are much safer. Office Scripts / Power Automate run on SharePoint / OneDrive. This is a much more secure environment than a user’s Desktop PC or network server.
Migrating from VBA to Office Scripts and Power Automate
I can assist with the successful migration from Excel VBA Macros to Office Scripts and Power Automate.
Designed for the Future
Excel VBA Macros have been around for a long time and now Microsoft are moving towards Office Scripts and Power Automate. Macros tend to be desktop / server based and have to be executed generally from a Super User’s PC. In contrast Office Scripts / Power Automate can be developed and run from any computer connected to the OneDrive / SharePoint. This could be anywhere in the world.
Please contact me for further assistance.
