title: Copy sheet from one WB to another using VBA without opening destination WB
body: <p>I'm new to VBA and trying to automate updates to a workbook.
  I have a source <em>Workbook A</em> and a destination <em>Workbook B</em>. Both have a sheet called <em>roll out summary</em>. I want the user to update this sheet in A and click update button which should run my macro. This macro should automatically update the sheet in workbook B without opening Workbook B. </p>
  
  <p>I'm trying this code but it doesn't work and gives me an error:</p>
  
  <pre><code>Dim wkb1 As Workbook
  Dim sht1 As Range
  Dim wkb2 As Workbook
  Dim sht2 As Range
  
  Set wkb1 = ActiveWorkbook
  Set wkb2 = Workbooks.Open("B.xlsx")
  Set sht1 = wkb1.Worksheets("Roll Out Summary") &lt;Getting error here&gt;
  Set sht2 = wkb2.Sheets("Roll Out Summary")
  
  sht1.Cells.Select
  Selection.Copy
  Windows("B.xlsx").Activate
  sht2.Cells.Select
  Selection.PasteSpecial Paste:=xlPasteFormulasAndNumberFormats, Operation:= _
      xlNone, SkipBlanks:=False, Transpose:=False
  </code></pre>