Use Dir in If statement to delete old file, save new file

I am trying to use and If statement to:

1. check and see if an old copy of a file exists in a folder,
2. and if so delete it,
3. then check to see if a new copy of a file exists in the same folder,
4. and if not save a copy.

I keep getting a Run-Time 13 error, Type Mismatch on the Dir statement, and endless searches have not yielded any results. Below I have pasted a sample of the code that I have tried (I have tried many different configurations with the Dir declaration, none have worked obviously). I have tried using variables where the full file path and file name are assigned to them, and also cutting them up into one variable that stores the path, and another variable that stores the file name.

Here is a sample:

Please Login or Register  to view this content.

Thank you

I'm guessing that the type mismatch is because Dir returns a string not true/false/empty

Please Login or Register  to view this content.

I've run into time where this hasn't picked up an existing file, so I tend to use a temporary variable to store the result of the DIR, and check that.

Please Login or Register  to view this content.

Had to go the temporary variable storage route, but it worked like a charm, thanks!