title: Running Excel macro from Outlook macro getting error 1004
body: <p>I have a rule in Outlook which is running a VBA script. This VBA is to open a local Excel file, and run the macro in the Excel file.</p>
  
  <p>When running, and opening the Excel file, I'm getting the error:
  Run-time error 1004: Cannot run the macro 'Ask me question workflow.xlsm!AskMeFlow'. The macro may not be available in this workbook or all macros may be disabled.</p>
  
  <p>When running the Excel macro from Excel, all is running fine.</p>
  
  <p>My code in Outlook:</p>
  
  <pre><code>Sub AskMeAlerts()
  
      Dim appExcel As Excel.Application
      Dim wkb As Excel.Workbook
  
      Set appExcel = CreateObject("Excel.Application")
      appExcel.Workbooks.Open ("C:\Ask me question workflow.xlsm")
  
      appExcel.Visible = True
  
      appExcel.Run "Ask me question workflow.xlsm!AskMeFlow"
  
      appExcel.ActiveWorkbook.Close
  
      appExcel.Quit
  
      Set appExcel = Nothing
      Set wkb = Nothing
  
  End Sub
  </code></pre>