title: Copy from one workbook into another using a file path name
body: <p>I am trying to run a macro using an <em>existing</em> workbook that 1) opens a different workbook I'll call <em>other</em> 2) copies values from <em>other</em> workbook 3) pastes values from <em>other</em> into <em>existing</em> workbook and 4) closes <em>other</em> workbook. Below is the code I have so far. Is there a way to better define or set y? My code works except I am not able to close <em>other</em> and I think if I had y better defined I could just use something like y.close. Thanks!</p>
  
  <pre><code>Dim x As Worksheet
  Dim y As Worksheet
  
  Set x = ActiveWorkbook.Sheets("File44")
  
  Workbooks.Open (ThisWorkbook.Path &amp; "\File44.xlsm")
  Workbooks("File44.xlsm").Activate
  
  Set y = ActiveWorkbook.Sheets("File44 - Detail")
  LastRow = y.Range("A" &amp; Rows.Count).End(xlUp).Row
  
  y.Range("A15:CQ" &amp; LastRow).Copy
  x.Range("A2").PasteSpecial xlPasteValues
  
  ActiveWorkbook.Close savechanges:=False
  </code></pre>