how do i wait till macro is finished to run auto it

[yasha]

$oExcel = ObjCreate("Excel.Application")                   ; Create an Excel Object
$oExcel.Visible = 1                                        ; Let Excel show itself
$oExcel.Workbooks.Open('J:\OPS\OPS_Share\Planners\7 - Automation\All Report macro.XLSM',0)
$oExcel.ActiveWorkbook.Application.Run("ECONOMICSTOCKCOMPILE")
$oExcel.ActiveWorkBook.Close
$oExcel.Quit
WEnd
;ProcessWaitClose("Proce.exe")
WinWaitActive(""& $YY & $MM & $DD & "range_Economic_stock.xls")
$oExcel = ObjCreate("Excel.Application")                   ; Create an Excel Object
$oExcel.Visible = 1  ; Let Excel show itself
$oExcel.ActiveWorkbook.SaveAs (  $sFileSelectFolder &"\"& $YY & $MM & $DD & " range_Economic_stock.xlsx",51,"","",False,False)
$oExcel.ActiveWorkBook.Close
$oExcel.Quit

my program runs fine only problem is that it does not wait till macro finishes any idea how wait until macro finishes .

[Marc]

If only one instance of excel is running (which is started by your script) you could simply use WinWaitclose.

or

while 1
  if not ProcessExists("excel.exe") Then ExitLoop
  Sleep(250)
wend

 

[FrancescoDiMuro]

@yasha

You could use _Excel_* functions to interact with Excel

[yasha]

@FrancescoDiMuro

ah thanks for your replies turns out i forget to add save function in macro so it closed the program after the macro ran but did not save my file so the autoit got stuck waiting for excel to activate lol .

Edited November 12, 2018 by yasha