title: VBA to add new sheet in a closed excel without opening & get the sheet name added?
body: <p>I have an excel "Closed.Xls" which is not opened currently.</p>
  
  <p>Please let me know how to add new sheets in to this closed excel file. I know how to add new sheets in current excel.</p>
  
  <pre><code>Dim WS as Worksheet
  Set WS = Sheets.Add
  </code></pre>
  
  <p>Please let me know how to</p>
  
  <ol>
  <li>add new sheets in a closed excel using VBA, and   </li>
  <li>get the name of the sheet added  </li>
  </ol>
  
  <p><em>Note: I don't want to rename the sheet.</em></p>
  
  <p>Thanks</p>