title: Run Macro in another excel, but fail to return to current sub after the called Macro completed
body: <p>ParentExcel.xlsm has sub to call a sub in ChildExcel1.xlsm and ChildExcel2.xlsm</p>
  <pre><code>//in ParentExcel.xlsm    
  Sub ParentSub()
  
      Set runWorkbook = Workbooks.Open(Filename:=mChildPath)
      Application.Run runWorkbookName &amp; &quot;!&quot; &amp; ChildSub1
  
      /*Edit*/Set runWorkbook2 = Workbooks.Open(Filename:=mChildPath2)
      Application.Run runWorkbookName2 &amp; &quot;!&quot; &amp; ChildSub2
  End sub
  
  //in ChildExcel1.xlsm
  Sub ChildSub1()
  
       MsgBox &quot;Called ChildSub1&quot;
       /*Added*/ThisWorkbook.Close
  
  End sub
  
  //in ChildExcel2.xlsm
  Sub ChildSub2()
  
       MsgBox &quot;Called ChildSub2&quot;
       /*Added*/ThisWorkbook.Close
  
  End sub
  </code></pre>
  <p>My problem is, the procedure stopped after completion of ChildSub1() and the ChildExcel1.xlsm is closed. I then cannot execute the remaining code in the ParentSub()</p>