FileLen

FileLen function determines the byte length of a file. The required File argument must be valid string expression representing a valid file name. File may contain a DOS path structure including directory or folder names, and a drive letter.

The FileLen function returns the size of a file immediately before it was most recently opened. To obtain the length of a file that is already open, use the LOF function.

Syntax

FileLen(File)

File:

A string or expression that can represent a valid file name, and may include a DOS path structure including directory or folder names, and a drive letter.

Return Value

Returns a Long value representing the length of the file measured in bytes.

Related Functions

EOF | Loc | LOF | Seek

Example

Dim lonFileSize As Long

lonFileSize = FileLen("C:\TESTFILE.txt")	' returns length of file 
in bytes