How to check if a file exists in a directory

[bnath005]

Set objFSO = CreateObject("Scripting.FileSystemObject")

If the file I am looking for doesn't exist, then the next line is causing an error.

Set objFile = objFSO.GetFile("C:\code\OpicsEod\file.txt")

thanks
much appreciated.
nath

 

[dm4ever]

If objFSO.FileExists("C:\code\OpicsEod\file.txt") Then
Set objFile = objFSO.GetFile("C:\code\OpicsEod\file.txt")
End If

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid

 

[PHV]

strPath = "C:\code\OpicsEod\file.txt"
If objFSO.FileExists(strPath) Then
Set objFile = objFSO.GetFile(strPath)
...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[bnath005]

thanks much.

I figured out.
nath