FileLen function
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
To obtain the length of an open file, use the LOF function.
Example
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).
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om