title: Running Excel VBA from MS Access VBA
body: <p>Spent some time researching and I cannot figure out whats wrong. </p>
  
  <p>Security Settings in both files are correct. The sub being called is public &amp; in a normal module. </p>
  
  <p>The error states "Cannot run macro blah blah blah...."</p>
  
  <p>Code: </p>
  
  <pre><code>Private Sub this()
      Dim xl As Object
      Set xl = CreateObject("Excel.Application")
      xl.Visible = True
      xl.Workbooks.Open "pathToFile" &amp; "\" &amp; "Dig IT.xlsm", True, False
      xl.Run "ThisWorkbook.Module3"
      Set xl = Nothing
  End Sub
  </code></pre>