SFtpDir Excel Class Module Reference Documentation

SFtpDir

Current Version: 9.5.0.90

Represents a remote SFTP directory listing.

Object Creation

Dim oSFtpDir As Chilkat.SFtpDir
Set oSFtpDir = Chilkat.NewSFtpDir

Properties

LastMethodSuccess
LastMethodSuccess As Long

Indicate whether the last method call succeeded or failed. A value of True indicates success, a value of False indicates failure. This property is automatically set for method calls. It is not modified by property accesses. The property is automatically set to indicate success for the following types of method calls:

  • Any method that returns a string.
  • Any method returning a Chilkat object, binary bytes, or a date/time.
  • Any method returning a standard boolean status value where success = True and failure = False.
  • Any method returning an integer where failure is defined by a return value less than zero.

Note: Methods that do not fit the above requirements will always set this property equal to True. For example, a method that returns no value (such as a "void" in C++) will technically always succeed.

top
NumFilesAndDirs
NumFilesAndDirs As Long (read only)

The number of entries in this directory listing.

top
OriginalPath
OriginalPath As String (read only)

The original path used to fetch this directory listing. This is the string that was originally passed to the OpenDir method when the directory was read.

top

Methods

GetFilename
GetFilename(index As Long) As String

Returns the Nth filename in the directory (indexing begins at 0).

Returns Nothing on failure

top
GetFileObject
GetFileObject(index As Long) As SFtpFile

Returns the Nth entry in the directory. Indexing begins at 0.

Returns Nothing on failure

top
Sort
Sort(field As String, ascending As Boolean)
Introduced in version 9.5.0.79

Sorts the files and sub-directories in ascending or descending order based on the field. Possible values for field are "filename", "filenameNoCase", "lastModifiedTime", "lastAccessTime", "lastCreateTime", or "size". (For case-insensitive filename sorting, use "filenameNoCase".)

top