Finding a file in a directory

[ritaab]

Hi,

How can I know if a file already exists in a directory?

[chrisjk]

use Dir on it

If Len(Dir$("c:\winnt\win.ini"))>0 then
    msgbox "Exists!"
else
    msgbox "Doesn't"
end if

[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"

[ritaab]

Thanks a lot.