title: vba - select first worksheet in a csv file
body: <p>I am trying to write a macro that pastes some data into a large number of csv files saved in a folder.  How do I get the macro to select the first worksheet in each csv file (csv files only have one worksheet)? If it was an Excel file I could do this:</p>
  
  <pre><code>Sheets("Sheet1").Select
  </code></pre>
  
  <p>However, each csv file has a different name for the worksheet.</p>