I am setting up a macro to copy a file from one directory, then save it to another with part of the name being the current day's date. For example: rename report.snp to report011706.snp.

Is there anyone out there that would know how to do this??

Thanks!