LOF

Returns a Long representing the size, in bytes, of a file opened by using the Open statement.

Syntax: LOF( filenumber )

filenumber
required Integer containing a valid file number.

Note

Use the FileLen function to obtain the length of a file that is not open.

Common Errors

Error When
-2147467259 (&H80004005), Unspecified error filenumber is not the number of an open file
94 (&H5E), Invalid use of Null filenumber is Null

Note BETA 1034

When filenumber is not the number of an open file, VB6 and 64-bit VBA raise error 52 (&H34), Bad file name or number, instead.

Example

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.

See Also