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?
Switch Script 2024
Re: Switch Script 2024
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.
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.