Visual Basic for Applications Reference
LOF Function
Returns a Long representing the size, in bytes, of a file opened using the Open statement.
Syntax
LOF(filenumber)
The required filenumberargument is an Integer containing a valid file number.
Note Use the FileLen function to obtain the length of a file that is not open.