Use the Dir function. Ex:

Dim strFile as string

strFile = Dir("c:\somefile.txt")

If Dir = "" Then
'file does not exist
Else
'file does exist and strFile now equals "C:\somefile.txt"
End If