Renaming Files- Name already exists Error Handling solution

[Carouser]

I am using the code, Rename "Name1" As "Name2" as part of a renaming and sending procedure. I am using a program generated naming convention for Name2. Is there a simple solution to compare if Name1 and Name2 exist before the error handler spoils everything if indeed there already is a file by the same name. As I have the full file paths for both names, would it be as simple as If Name1 = Name2, then msgbox "Name Already exists" and End, else continue. Everything I've looked at seems to want to create a separate function, or others say use FSO (though there seems to be a vehement debate about using FSOs). There must be a basic solution without adding further declarations and functions to my code. You probably gathered that I'm not a programmer, but any direction or resources would be appreciated.

[pbaldy]

You can use the Dir() function to see if the file exists already.

[Carouser]

Very Cool! It took me a while to find it, but here it is in all its simplitic glory doing what I need it to do. Thanks pbaldy for pointing me in the right direction.

'Check if file exists
            
If Dir(NNPath) <> "" Then
 
                MsgBox "File Already Exists!!! Please check Your Files"
 
                    'Else
 
                        'MsgBox "No Go!"
                           

                            End  ' I added this so it will go no further
                            End If

[pbaldy]

Happy to help!

[Carouser]

Initially I was looking for a method of checking to see if a folder exists so that when renaming, you will avoid having 2 folders with same name, and causing an error. The code certainly does that. But I also need to see if the file exists, not for duplicate file purposes, but if it does, then bypass renaming and go to the send procedure. Is there a method to distinguish between duplicating files as opposed to just the one file with the same name?

[pbaldy]

Sorry, but I don't understand what you're asking. You can use the function to see if a directory or file exists, and respond accordingly with your code logic.

[Carouser]

Dir() is doing what it is supposed to do, and I realized what I am asking has everything to do with error handling which, admittedly, is on my learn to do list. Thanks Paul and onwards on the db journey.

[pbaldy]

Here are the basics of error handling:

http://www.baldyweb.com/ErrorTrap.htm

But I'm of the school of thought that thinks you should prevent errors from happening when you can foresee them. I don't understand what problem you're having with Dir() that error handling will catch.