title: running multiple macros in order across multiple excel workbooks - vba
body: <p>I have multiple excel workbooks each representing a days data, each workbook has multiple sheets representing each event on the day.. </p>
  
  <p>i need to run 6 macros in order across each sheet in a workbook and then move on to the next workbook (all the workbooks are in the same folder on the desktop) </p>
  
  <p>at the moment im using this (below) to run the macros in order across all the sheets but im having trouble trying to get somthing to run across all of the workbooks </p>
  
  <pre><code>Sub RUN_FILL()
  Dim sh As Worksheet
  
  For Each sh In ThisWorkbook.Worksheets
  sh.Activate
  
  Call macro_1
  Call macro_2  
  Call macro_3  
  Call macro_4  
  Call macro_5  
  Call macro_6
  
  Next sh
  End Sub
  </code></pre>
  
  <p>any idea how i might do this ?</p>