VBA to save multiple worksheets as separate CSV files using name of worksheet

Hi

I tried to adopt Martin's code (from a separate thread) as my requirement was very similar. I have data in the following format per tab in excel 2010

AC ME ACME CO
Date PX_OPEN PX_HIGH PX_LOW PX_LAST
27/09/2011 1108.23 1141.13 1075.33 1108.23
28/09/2011 1130.33 1163.47 1097.19 1130.33
29/09/2011 1145.81 1180.21 1111.40 1145.81

i need to save each tab in excel as a .CSV file in a folder (any name will do). The number of tab's(worksheet's) will vary - anything from 1 to N tabs. So basically the vba would need to create N CSV files. Also - as the tab data will be updated daily - i would need to overwrite the old .CSV files.

Any help - will be greatly appreciated.

Many thanks

ACTUALLY - APOLOGIES. I HAVE SORTED IT NOW. It was just to change the "CSV" name to "NAME" (as per spreadsheet)

Give this a try. Will save the files to the same directory as the workbook.

Please Login or Register  to view this content.

If you have solved your question (even if its done by you)

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.