Function that tells if string entry is a file

[ziwacky]

Hi there,

Is there any function that will tell me if the user entry (to a textbox, so it is a string) is a file. Maybe something like IsFile(txtFile).

Thanks,

Z

 

[sdimov]

Dim sFile as String

sFile="c:\temp\MyFile.txt"
If Len(Dir(sFile))>0 Then
'File exists
Else
'File does not exist
End If