Hello. I have two questions. I have a macro that opens a bunch of files,
does stuff to them and then saves them based on the contents in a few cells.
Is there a way to automatically append a "(1)" to a file if the file name
already exist? And then increment the number accordingly?

My second ? is that I have an "On Error Goto" statement but it only runs one
time. The macro loops as many times as there are files in the folder but if
the specific error happens more than once it doesn't execute the "On Error
Goto" command again.

Thanks in advance for the help