title: How To Call a Subroutine From Another Object
body: <p>I am not entirely sure if this is possible, but assuming with us being able to set object references I don't see why not.</p>
  
  <p>To start off, the object that contains the subroutine in question is Excel itself. I am wanting to call one of Excel's VBA subroutines using a different program's VB6 script editor.</p>
  
  <p>I have tried the following without success, but hopefully you can see what I am trying to accomplish here:</p>
  
  <pre><code>Sub Excel_Test()
      Dim appXL As Object
      Set appXL = GetObject(, "Excel.Application")
  
      Call appXL.Project1.Module1.Test()
  End Sub
  </code></pre>
  
  <p>Obviously this code is not working - but what would be the proper Syntax (if one exists) to call the Macro <code>Test</code>, located in <code>Module1</code> contained in Excel's object?</p>