title: Running a Macro from a VBS File Giving Error
body: <p>I am using a vbs code to open and run an Excel macro automatically but getting the following error message: </p>
  
  <p><strong>Error:</strong> Cannot run the Macro "file location". The macro may not be available in this workbook or all macros may be disabled. 
  Code: 800A03EC
  Source: Microsoft Excel </p>
  
  <p><strong>VBS Code:</strong> </p>
  
  <pre><code>Dim ObjExcel, ObjWB
  Set ObjExcel = CreateObject("Excel.Application")
  ObjExcel.Visible = True
  
  
  Set ObjWB = ObjExcel.Application.Run("C:\Automation\TestCasesBackupScript.xlsm!Backup3")
  
  
  ObjWB.Close False
  ObjExcel.Quit
  Set ObjExcel = Nothing
  </code></pre>
  
  <p>Macro is enabled and the "Backup3" is the Sub name in a module of TestCasesBackupScript.xlsm file. </p>
  
  <p>Hoping for feedback.</p>
  
  <p>Thank you.</p>