Good morning,

I am looking for a code that will save the file from the contents of A1 and change the format of the excel spreadsheet to comma delimited.

My problem is that the contents of A1 is a date and i think i am getting an error because the date contains forward slashes (00/00/000) and i believe that that is a invalid character to have as a file name.

What i am looking for is to take the contents of A1 which will be in the format of 00/00/0000 but save it in the filename as 00_00_0000.

I currently have this simple code, if any one can tweak it to achieve the results i am looking for i would greatly appreciate it.

Public Sub SaveAsA1()
ThisFile = Range("A1").Value
ActiveWorkbook.SaveAs Filename:=ThisFile, FileFormat:=xlCSV

End Sub