Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

FileLen Function

Last modified: December 06, 2011

Applies to: Office 2013 | VBA

Returns a Long specifying the length of a file in bytes.

Syntax

FileLen( pathname )

The required pathname argument is a string expression that specifies a file. The pathname may include the directory or folder, and the drive.

Remarks

If the specified file is open when the FileLen function is called, the value returned represents the size of the file immediately before it was opened.

Note Note

To obtain the length of an open file, use the LOF function.

This example uses the FileLen function to return the length of a file in bytes. For purposes of this example, assume that TESTFILE is a file containing some data.

Dim MySize
MySize = FileLen("TESTFILE")    ' Returns file length (bytes).


Show:
© 2015 Microsoft