title: Excel VBA refusing to Activate a workbook
body: <p>I'm currently writing this program that gets information from other workbooks and organizes them in another workbook. I am trying to activate one of the workbooks that information comes from and it is refusing to activate. I have used this exact syntax before and it has worked, so I'm a little confused why the workbook is not activating. I have confirmed the pathing is correct and the file name is correct. Line 2 is where the issue is <code>"brakes(i)"</code> and <code>"shift(k)"</code> are arrays getting ran through a for loop to retrieve different CSV files, but instead of activating that workbook it reverts back to the workbook the code is written in. I hope this explanation makes sense :P</p>
  
  <pre><code>Workbooks.Open Filename:=fp3
      Worksheets(brakes(i) &amp; shift(k) &amp; "PartsLog").Activate
  </code></pre>