Switch Script 2024

Post Reply
jterrano
Newbie
Posts: 6
Joined: Thu Nov 04, 2021 8:00 pm

Switch Script 2024

Post by jterrano »

It has been stated that come 2024 - Switch Scripting will only support nodejs scripting.

With that said - would there be any methods available of executing excel macros with nodejs?
freddyp
Advanced member
Posts: 1008
Joined: Thu Feb 09, 2012 3:53 pm

Re: Switch Script 2024

Post by freddyp »

There are packages for Node.js that allow you to do stuff with Excel files, but these work on the file format. Running macros is not a part of that.

What you can already do today is to run a Powershell script that runs a macro in Excel using "Execute command". Just search for "powershell execute macro excel" on the internet and you will find a lot of information on how to create such a script.
Post Reply