Run Excel Macro from VBS or BAT file

[Ulisses_Carso]

Hi everyone, I have this macro that I need to run every day, I always have to open Excel App to open Personal.xslb with all my Macros and then run the macro I need.

Is there a way to use bat or vbs to create an executable for this macro? I'm not familiar with VBS or Batch files to do this.

 

[Logit]

Excel was not designed to be made into an executable.

You can use the Windows Scheduler program (built-in to Windows) to run a workbook that contains only the macro you wish to activate.
The macro would be run when the workbook opens : Sub Workbook_Open()