Fastest way to check if file exists

[bradyboyy88]

I have 1000s of files to sort through in a directory and I was wondering if anyone has experience on which is the best way to check if a file exists. From my research the two approaches are the Dir function and the other is to createa a filesystemobject and use FileExists function. Does anyone know which is naturally faster in their search function?

Thanks

 

[bradyboyy88]

Actually,

I am not sure how to use the shell dir command from that post. Is this the correct syntax? Also, since exec brings up the command window is there a way to do this with run to hide the window?

sub testdir()
Dim FilePath as String
Dim FileExist as Boolean

FileExist =CreateObject("WScript.Shell").Exec("cmd /c dir " & """" & FilePath & """" & " /b /s").StdOut.ReadAll

Msgbox FileExist
End Sub

 

[Fluff]

I'm afraid I've no idea, as I've never used it myself.