title: Copy Range between two instances of excel
body: <p>I'm running two separate instances of Excel and I'm trying to copy data from a Range in one workbook to the other.</p>
  
  <p>I have this code:</p>
  
  <pre><code>Sub CopyValues()
  Dim xlApp As Excel.Application
  Set xlApp = GetObject(, "Excel.Application")
  Dim Src As Range
  Dim Dst As Range
      Set Src = xlApp.ActiveSheet.Range("A1:A9")
      Set Dst = Workbooks("Book1.xlsm").Worksheets("Sheet1").Range("A1:A9")
      Src.Copy Dst
  End Sub
  </code></pre>
  
  <p>It doesn't return any errors but it doesn't copy the values,
  Also tried this for the last line</p>
  
  <pre><code>Src.Value = Dst.Value
  </code></pre>
  
  <p>Still does nothing</p>
  
  <p>My VBA skills are not so good, just started learning it 2 weeks ago.</p>