title: Trying to open a Workbook and a run a macro in that file
body: <p>I have a workbook which opens up another workbook (filename is based on a cell value) and then runs a macro called Single_sector within that file.</p>
  
  <p>It opens the file perfectly fine but doesn't run the macro. Any ideas?</p>
  
  <pre><code>Sub run_all()
  Dim Location
  
  
  
  On Error Resume Next
  
  'Location of file to open
   Location = Worksheets("Main").Range("folder_location").Value
  
  'Open F&amp;V File
  Application.Workbooks.Open Location &amp; Range("fv_file").Value
  'Run Macro
  Run ("Single_sector")
  
  
  
  End Sub
  </code></pre>