checking if a file exists

[si_the_geek]

Originally posted by bezaman
What would be the best way to figure out if a certain file exists? I was thinking about using the File System Objects. Does anybody know how to do this?

It's a little easier than that:

eg:
this will show a message if the file Test.Txt exists in the folder C:\Temp

If Dir("c:\temp\test.txt") <> "" Then Msgbox "File Exists!"