title: Import data from Two open workbooks with variable names
body: <p>I´m trying to activate, process data and import information from two different open workbooks(BCH mm-yy.xlsx and Portafolio mm-yy.xlsx), where mm-yy changes every month.</p>
  
  <p>As an example of how to activate both workbooks i did the following:</p>
  
  <pre><code>Sub ActivateWorkbook()
  
      FName1 = Dir("c:\BCH" &amp; "??-??" &amp; ".xlsx")
      Range("A5").Select
      ActiveCell.FormulaR1C1 = "OK"
  
      FName2 = Dir("c:\Portafolio" &amp; "??-??" &amp; ".xlsx")
      Range("A3").Select
      ActiveCell.FormulaR1C1 = "OK"
  
  End Sub
  </code></pre>
  
  <p>The problem is that when I run the macro it doesn´t identify which workbook I am refering to and it performs the tasks (write OK as an example) in just one of the workbooks. That is, it writes "OK" in cells A3 and A5 in BCH workbook when it should write "OK" in A5 from BCH and A3 of Portfolio. Any advice on how to solve it?</p>