Hello Everyone,

I am trying to write a macro that will automatically add (2), (3), (4)....respectively to the end of a filename if the filename already exists. I currently am using a master file that starts up automatically and saves the file based on the date. My problem is if the computer is shut down and restarted, it recognizes that the file already exists for that date and will not automatically save the file. I would like to automatically save the file under the same name, but with the appropriate number at the end indicating there are more than one file with the same name.

If anyone knows how to do this with vba, I would greatly appreciate the help.

Thanks,
Jared