View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LostInNY LostInNY is offline
external usenet poster
 
Posts: 20
Default Creating CSV for every Excel Tab

Hi all. I need a way to create a new CSV file for every Excel tab I have in
a workbook whenever a user saves the workbook. The workbook has tabs 1-20
and the data is from A1 to EP5000. When the workbook is updated and saved I
need to generate a new CSV that has the same name as the tab it originated
from. Any ideas?