I've got it to append the date to the filename now but I'm having trouble
with it saving the file on the network drives. Any idea on how to get it to
do both functions. Append date to filename and save in a new location. Thanks

"SKelley" wrote:

I need to save a copy of a file each day the macro runs to a network
location. What is an easy way to code it to append the date to the front of
the file name so each time the file is rerun it won't write over the previous
file?