Skip to main content

LOF function

Table of contents
  1. Syntax
  2. Example

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



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


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.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>