title: Copy and paste values from a workbook into a closed workbook
body: <p>I'm fairly new to VBA coding, so please pardon any ignorance.
  How can I copy from one sheet (DIC) in workbook 1 and paste values in a sheet (Archive) in a second workbook starting from the first empty row? I don't have the second worksheet open often, so if it can be done without keeping it open, that would be preferred.</p>
  
  <p>I compiled a code to get it to copy into a second sheet within the same workbook, but I'm stumped when it comes to getting it into the second workbook.</p>
  
  <p>Here's the code that I have so far: </p>
  
  <pre><code>    Sub copytoarchive()
  
  'Copy From DIC
      Sheets("DIC").Select
      Range("A4:Q4").Select
      Range(Selection, Selection.End(xlDown)).Select
      Selection.Copy
  
  'Paste into Archive
      Sheets("Archive").Select
       Dim NextRow As Range
       Set NextRow = Range("A65536").End(xlUp).Offset(1, 0)
      NextRow.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
      :=False, Transpose:=False
  
  'Clear Memory
      Set NextRow = Nothing
  
      End Sub
  </code></pre>