Macro to check if a file existists in the same folder

[tonywatsonhelp]

Hi everyone,
I have a macro that creates a file called "Times.xlsx" in the same folder the excel doc is in.
I'd like to check if its already been created before running the macro.
so I need a bit a the beginning that can look an this workbook filepath and see if a folder called "Tomes.xlsx" is present if it is give me a message box saying "File already exists" and exit sub, if not carry on.
please help if you can.

thanks

Tony

 

[footoo]

Dim s$: s = ThisWorkbook.Path & "\Times.xlsx"
If Dir(s) <> "" Then
    MsgBox "File already exists"
    Exit Sub
End If

 

[tonywatsonhelp]

Thank you footoo,
this is great
Tony