title: Getting "Cannot Run the Macro..." Error in VBA
body: <p>I recently learned how to program in VBA and have gotten some extremely helpful assistance by reading through the previously asked questions and answers on this site. However, I have encountered a problem in one of my programs that doesn't appear to be addressed very directly. So I'll ask it here.</p>
  
  <p>I am making a Powerpoint macro that will automatically update some slides with new data. For one slide that contains an excel table, I want the macro to open up an excel file, run an existing macro in the excel file to populate the spreadsheet with new data, and finally copy the table over to the powerpoint slide. My code so far (without the copy over portion) is this:</p>
  
  <pre><code>Private Sub GetProposals()
      Dim myXL As Excel.Application
      Dim myXLS As Excel.Workbook
      Dim ws As Excel.Worksheet
  
      Set myXL = New Excel.Application
      Set myXLS = GetObject("K:\Jackson\Proposal Summary Master.xlsm")
      Set ws = myXLS.Sheets(1)
      ws.Visible = xlSheetVeryHidden
  
      myXLS.Sheets("VLOOKUP").Range("J1").Value = "EPL"
      myXL.Run ("'K:\Jackson\Proposal Summary Master.xlsm'!BABox_Change")
  End Sub
  </code></pre>
  
  <p>It runs correctly until I reach the "myXL.Run..." line. I get a message saying "Run-time error '1004': Cannot run the macro "K:\Jackson\Proposal Summary Master.xlsm'!BABox_Change'. The macro may not be available in this workbook or all macros may be disabled."</p>
  
  <p>The excel macro runs fine when I open up the file directly and start it that way. I am somewhat stuck on what I should do next. Does anyone have some suggestions?</p>