Determining if a file exists

[CaKiwi]

What is the best way to determine if a file exists? My current method is to try opening it or to call FileDateTime to see if I get an error but I thought there might be a more elegant way.

CaKiwi

"I love mankind, it's people I can't stand" - Linus Van Pelt

 

[Spellman]

Hi,

You can use the Dir() function as in

If Dir(path & filename) <> &quot;&quot; then
code
End if

Mark

The key to immortality is to make a big impression in this life!!

 

[CaKiwi]

Thanks, that should work. I'll try it tonight.

CaKiwi

&quot;I love mankind, it's people I can't stand&quot; - Linus Van Pelt

 

[aco2x]

You might consider using the FileSystemObject, which has a FileExists method you can interrogate:

object.FileExists(filespec)

The FileExists method syntax has these parts:

Part Description
object Required. Always the name of a FileSystemObject.
filespec Required. The name of the file whose existence is to be determined. A complete path specification (either absolute or relative) must be provided if the file isn't expected to exist in the current folder.