Rename file with added date

SandySun · Aug 25, 2008

Does anyone know how to rename a file with today's date and time at the end?

Name C:\My.mdb" As "C:\My-1122-082508.mdb"

Cheers

Douglas J. Steele · Aug 25, 2008

Name "Name C:\My.mdb" As "C:\My-" & Format(Now, "hhnn\- mmddyy" & ".mdb"

SandySun · Aug 25, 2008

Perfect!!!! Thanks Douglas!

Douglas J. Steele said:
Name "Name C:\My.mdb" As "C:\My-" & Format(Now, "hhnn\- mmddyy" & ".mdb"