Feb 17 2020 02:47 AM
Hello All,
I have an excel macro with lot of formulas which takes 1 hour to execute and get the job done.
I also have a powershell script that calls the excel macro.
I would like to ask if calling a macro from powershell can speedup the execution than that of excel or not?
I would appreciate any help on this.
Thanks,
Yogendra
Feb 19 2020 11:25 AM
@YKPS_21 I would say no, as calling it out from PS will execute/open excel to do it resulting in using the same resources and processes.
In order to speed it up, I would try to import the data into PS and work directly in there if necessary work with Runspaces to process the data in parallel.