'Create Excel App Instance & Open Xlsm File Set objExcelApp = CreateObject("Excel.Application") objExcelApp.Visible = True objExcelApp.DisplayAlerts = False 'Define Macro File & Path sFilePathXlsm = "E:\AutoRun\Test Macro Run from Other Workbook VBS.xlsm" Set iWb = objExcelApp.Workbooks.Open(sFilePathXlsm) '1. Run 1st Macro in another Excel sMacroToRun = "'" & sFilePathXlsm & "'!runfromothermacro1" objExcelApp.Run sMacroToRun 2. Run 2nd Macro in same file sMacroToRun = "'" & sFilePathXlsm & "'!runfromothermacro2" objExcelApp.Run sMacroToRun 'Save & Close file iWb.Save iWb.Close objExcelApp.DisplayAlerts = True objExcelApp.Quit