check file existence

[peggypph]

I would like to have a routine to check file existence under VBA.

Pls. give me some example. Thanks

 

[=TB=]

Dim fLen As Integer, filepath As String
filepath = "c:\SomeFile.txt"
On Error Resume Next
fLen = Len(Dir$(filepath))
If Err Or fLen = 0 Then
MsgBox ("The File Does Not Exist")
Else
MsgBox ("The File Does Exist")
End If

Is this what you are after?

 

[ghudson]

If Dir("C:\Temp\testing.txt") <> "" Then
    MsgBox "File does exist."
Else
    MsgBox "File does not exist."
End If