title: How to activate a workbook that is open using the name of the workbook in VBA
body: <p>I have already a one workbook open but I am running a macro from another workbook. I would like to activate the first workbook using its name.</p>
  
  <p>The code:</p>
  
  <pre><code>FileName = input_path_1 &amp; input_file_1
  Workbooks(FileName.xls).Activate
  </code></pre>
  
  <p>When I try to do so, it is giving me "Subscript out of range" error. How do I solve it?</p>