title | keywords | f1_keywords | ms.assetid | ms.date | ms.localizationpriority | |
---|---|---|---|---|---|---|
LOF function (Visual Basic for Applications) |
vblr6.chm1008965 |
|
1bf66bce-d3d7-9c34-e8d2-8ad1e1ee24a8 |
12/13/2018 |
medium |
Returns a Long representing the size, in bytes, of a file opened by using the Open statement.
LOF(filenumber)
The required filenumber argument is an Integer containing a valid file number.
Note
Use the FileLen function to obtain the length of a file that is not open.
This example uses the LOF function to determine the size of an open file. This example assumes that TESTFILE
is a text file containing sample data.
Dim FileLength
Open "TESTFILE" For Input As #1 ' Open file.
FileLength = LOF(1) ' Get length of file.
Close #1 ' Close file.
[!includeSupport and feedback]