FileSystemObject : FileExists Method

by 
Description:

Returns True if a specified file exists; False if it does not.

Format :

objectOfFileSystemObject. FolderExists(fileName)

objectOfFileSystemObject : As the names says, it’s a FileSystemObject.

Arguments:
    • fileName
      • Mandatory
      • Type:     String
      • File , whose existence to be determined.

Function FnIsFileExist(strCompleteFilePath)
      Set fso = CreateObject("Scripting.FileSystemObject")
      If fso. FileExists(strCompleteFilePath)Then
                    strStatus = strCompleteFilePath & “  file exists”
            Else
                    strStatus = strCompleteFilePath & “  file does not exist”
           End If
        FnIsFolderExist = strStatus
End Function

Msgbox FnIsFileExist (“c:\New Folder\file.txt”)