Finding a file in a directory

[nishantp]

Function FileExist(ByVal strPath As String) As Boolean
    FileExist = Len(Dir(strPath)) <> 0
End Function

If you dont want to put in the full path every time and only check within 1 directory, before you call the function do this:

ChDir "C:\MyDir"