I have a workbook with 3 sheets, one of which contains a file name in the
following format: "WE-MMDDYY". I need a macro that will save this workbook
as a CSV file with the name derived from the worksheet with the "WE-MMDDYY"
format.

Any help would be greatly appreciated.