Export (0) Print
Expand All
Expand Minimize

LOF Function

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

Syntax

LOF( filenumber )

The required filenumber argument is an Integer containing a valid file number.

Note 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.


Community Additions

ADD
Show:
© 2014 Microsoft