title: How to copy only a single worksheet to another workbook using vba
body: <p>I have 1 <code>WorkBook("SOURCE")</code> that contains around 20 Sheets.<br>
  I want to copy only 1 particular sheet to another <code>Workbook("TARGET")</code> using Excel VBA. </p>
  
  <p>Please note that the "TARGET" Workbook doen't exist yet. It should be created at runtime.</p>
  
  <p><strong>Methods Used -</strong> </p>
  
  <p>1) <code>Activeworkbook.SaveAs</code> &lt;--- Doesn't work. This will copy all the sheets. I want only specific sheet.</p>