MS-Excel / General Formatting

File and Directory Functions

FunctionWhat It Returns
CurDir(drive)The current directory as a Variant.
CurDir$(drive)The current directory as a String.
Dir(pathname, attributes)The name, as a Variant, of the file or directory (folder) specified by pathname and satisfying the optional attributes (for example, vbHidden). Returns Null if the file or directory doesn't exist.
Dir$(pathname, attributes)The name, as a String, of the file or directory (folder) specified by pathname and satisfying the optional attributes (for example, vbHidden). Returns Null if the file or directory doesn't exist.
EOF(filenumber)True if the end of file specified by filenumber has been reached; False otherwise.
FileAttr(filenumber, returnType)The file mode (if returnType is 1) or the file handle (if returnType is 2) of the file given by filenumber.
FileDateTime(pathname)The Date that the file given by pathname was created or last modified.
FileLen(pathname)The length, in bytes, of the file given by pathname.
FreeFile(rangenumber)The next available file number available to the Open statement.
GetAttr(pathname)An integer representing the attributes of the file given by pathname.
Loc(filenumber)The current read/write position in an open I/O file.
LOF(filenumber)The size, in bytes, of an open I/O file.
Seek(filenumber)The current read/write position, as a Variant, in an open I/O file.
Shell(pathname, windowstyle)The task ID of the executed program given by pathname.
[Previous] [Contents] [Next]