Save as Macro

M

MikeD1224

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.
 
B

Bob Phillips

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

--
---
HTH

Bob

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