title: Batch/VBS script to save Excel file as is
body: <p>Is there a way to automate opening every file in a given directory and doing the following:</p>
  
  <ol>
  <li>Open the CSV file</li>
  <li>Save the CSV file (prompts"the file may contain features that are not compatible with CSV. Do you want to keep the workbook in this format?)</li>
  <li>Select Yes</li>
  <li>Close the file (prompts "Do you want to save the changes you made to fileName.csv?") </li>
  <li>Select Yes</li>
  </ol>
  
  <p>The CSV file comes in from a remote server and is incompatible at first.  When I manually open and save then close the file it gets a tiny bit smaller in size then is compatible to use.  I'm assuming there is some difference such as removing commas or semi colons.</p>
  
  <p>Would using a VBS script be the best way to handle a problem like this?  And how would I write a script for the save as part?</p>