title: Combine several Excel files into one using VB
body: <p>I have a folder with several excel files that have a date field, i.e. 08-24-2010-123320564.xls. I want to be able to have some VB scripting that will simply take the files that start with todays date and merge them into one file. </p>
  
  <blockquote>
    <p>08-24-2010-123320564.xls
    08-24-2010-123440735.xls
    08-24-2010-131450342.xls</p>
  </blockquote>
  
  <p>into </p>
  
  <blockquote>
    <p>08-24-2010.xls</p>
  </blockquote>
  
  <p>Can someone please help? </p>
  
  <p>Thanks</p>
  
  <p>GabrielVA</p>