Jeff,
I just found something easy
Sub test()
Dim EDate As String
EDate = Date
EDate = Format(EDate, ("DD-MM-YYYY"))
MsgBox EDate
End Sub
I need the date also as part of a filename, so i need the - in it, no \
I just learned about the split finction, new to me.Really handy. You know VBA is pretty unknown to me.
Thanks
Bernd