title: Copying Between Workbooks with Varying Names
body: <p>I am attempting to copy/paste values from one open workbook to another.
  Neither of the workbooks will have static names, so there will be no name consistency.
  Both of my workbooks will be open and will be the only open files.</p>
  
  <p>Can someone help me fix this code to work when I don't know the file names?</p>
  
  <pre><code>Range("M7:R19").Select
  Selection.Copy
  Windows("new template.xlsm").Activate
  Range("M7").Select
  Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
      :=False, Transpose:=False
  Windows("old template.xlsm").Activate
  Range("S7:AT16").Select
  Application.CutCopyMode = False
  Selection.Copy
  Windows("new template.xlsm").Activate
  Range("U7").Select
  Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
      :=False, Transpose:=False
  </code></pre>