// .vbs file Dim args, objExcel set args = wscript.Arguments set objExcel = createobject("Excel.Application") objExcel.workbooks.open args(0) objExcel.visible = True objExcel.Run "Module1.Macro1" objExcel.Activeworkbook.Save objExcel.Activeworkbook.Close(0) objExcel.Quit // .bat file cscript "C:\Users\phareh_92(2)\Documents\X.vbs" "C:\Users\phareh_92(2)\Documents\Y.xlsm"