check if file exists

[harrisw]

Hi

I need to check whether a file exists before continuing the code.

Not sure haw to check if a file exists.

Thanks in advance

 

[Rob.Mills]

You need to add a reference to Microsoft.ScriptingRuntime

Then in your sub

Dim fso as New FileSystemObject

If fso.FileExists("Full Path") Then

 

[ghudson]

If you prefer not to deal with references then use the Dir() function.

    If Dir("X:\YourFile.txt", vbNormal) <> "" Then
        MsgBox "Files exists."
    Else
        MsgBox "Files does not exist."
    End If