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.

ActiveWorkbook.SaveAs Range("A1").Text, FileFormat:=xlCSV

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"MikeD1224" wrote in message
...
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.