(Excel) Check if File Exists

Demonstrates how to check to see if a file exists.

Download Excel Class Modules Chilkat Excel Class Modules

' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.

Dim sftp As Chilkat.SFtp
Set sftp = Chilkat.NewSFtp

' Connect to the SSH server.  

hostname = "sftp.example.com"

port = 22

success = sftp.Connect(hostname,port)
If (success <> True) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

' Authenticate with the SSH server.  Chilkat SFTP supports
' both password-based authenication as well as public-key
' authentication.  This example uses password authenication.
success = sftp.AuthenticatePw("myLogin","myPassword")
If (success <> True) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

' After authenticating, the SFTP subsystem must be initialized:
success = sftp.InitializeSftp()
If (success <> True) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

' Check to see if a file exists

' The return value is one of the following values:
' -1: Unable to check. Examine the LastErrorText to determine the reason for failure.
' 0: File does not exist.
' 1: The regular file exists.
' 2: It exists, but it is a directory.
' 3: It exists, but it is a symlink (only possible if followLinks is false)
' 4: It exists, but it is a special filesystem entry type.
' 5: It exists, but it is an unkown filesystem entry type.
' 6: It exists, but it is an socket filesystem entry type.
' 7: It exists, but it is an char device entry type.
' 8: It exists, but it is an block device entry type.
' 9: It exists, but it is an FIFO entry type.


followLinks = True

status = sftp.FileExists("someDir/someFile.txt",followLinks)
If (status < 0) Then
    Debug.Print sftp.LastErrorText
    Exit Sub
End If

Debug.Print "status = "; status

Debug.Print "Success"