I use code like the following to move or copy files to destination folders. If a file name already exists it will add a number to the file name like MyFile(1).txt, etc.
Public Sub MoveFileRename(SourceFile As String, DestFolder As String, Optional CopyF As Boolean = False)
If...