title: Pushing data from one workbook to another
body: <p>I have an Excel workbook <code>book1.xlsm</code> and another one as <code>book2.xls</code>. I want to push values from <code>book1</code> to <code>book2</code> via a macro running in <code>book1</code>.</p>
  
  <p>Is there a way in which even if the workbook <code>book2</code> is closed the value is pushed to it?</p>
  
  <p>The main reason for asking this is that it will skip the problem of saving <code>book2</code> again and again after a new value is inserted.</p>