title: VBA Run-time error '9': Subscript out of range; trying to activate another workbook
body: <p>I'm trying to create a VBA in Excel 2010 that takes info from another spreadsheet that I'm not allowed to alter and bring it over to the spreadsheet with my macro built in. Here's my code:</p>
  
  <pre><code>Sub BringUpWorkbook()
      Workbooks("RITE 1624.xls").Activate
  End Sub
  </code></pre>
  
  <p>I have several VBA books, have visited dozens of sites on the Internet, including those here at stackoverflow.com, and cannot find a reason why I'm receiving the run-time error. The workbook is already open, I've tried adding everything trailing the title, I've tried removing the <code>.xls</code>, I've even did all of the above with in a variable. Any ideas?</p>