// .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"
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter