title: Save each sheet in a workbook to separate CSV files
body: <p>How do I save each sheet in an Excel workbook to separate <code>CSV</code> files with a macro?</p>
  
  <p>I have an excel with multiple sheets and I was looking for a macro that will save each sheet to a separate <code>CSV (comma separated file)</code>. Excel will not allow you to save all sheets to different <code>CSV</code> files.</p>