title: Run another macro in another Excel file
body: <p>Hi so I am building an Excel system to run macro for running several different Macros on other Excel files.</p>
  <p>Let's say I have two Excel files: &quot;Parent.xlsx&quot; and &quot;child.xlsx&quot; opened already.</p>
  <p>In my Parent.xlsx I am running an VBA script, how can I run a macro called &quot;method1&quot; in my &quot;PERSONAL.XLSB&quot; for my &quot;child.xlsx&quot;</p>
  <p>Right now, in my Parent.xlsx, I try to run this macro VBA script:</p>
  <pre><code>Workbooks(&quot;child.xlsx&quot;).Application.Run &quot;PERSONAL.XLSB!method1&quot;
  </code></pre>
  <p>In my PERSONAL.XLSB in Modelue6, I have:</p>
  <pre><code>Sub method1()
      Dim rTable As Range
      Selection.AutoFilter
  End sub
  </code></pre>
  <p>Error:
  Run-time error'1004':
  AutoFilter method of Range class failed</p>
  <p>Thank you very much!</p>