Renaming file names

[sdefl]

I developed a process that imports several specific file names into access - for a reporting process... Instead of having the user go into windows explorer and rename the file to add the date onto the file name - I want it to be done automatically.. especially because another process may deal with scheduled 20 files dropped off to a server that will be imported weekly. What is the easiest way to have the files on the server automatically get the file creation date attached to the name and then copied to a history folder on the network... Thanks sarah

 

[Keith P]

You may find the FileDateTime function useful, and the Name statement, e.g. Name oldname As newname