Greetings,

The code below works fine. Cell B1 is a date created by a the formula =today()

Sub test()
ActiveSheet.Copy
ActiveWorkbook.SaveAs Range("B1")
ActiveWorkbook.Close
End Sub

When I run the macro it works, and saves the file, but it saves it as the numerical value for the date, and now the actual date.

How do I write in a format so that the true date appears in the saved file name.

Thanks