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)