This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.
Returns a Long specifying the length of a file in bytes.
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.
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).