Forum Discussion

YKPS_21's avatar
YKPS_21
Copper Contributor
Feb 17, 2020

Macro call from powershell

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

Windows PowerShell
  • Erick A. Moreno R.'s avatar
    Erick A. Moreno R.
    Iron Contributor
    Feb 19, 2020

    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. 

Resources