<div>
Are you getting the file from a server? If so can your query that server for COUNT?
</div>

<div>
you probably can load the text field into a ADO&nbsp;Recordset object and then look for the last record to get the value. like this: <pre><code class="code-10 nolinks" id="code-20-43080871-1">Public Function LoadText() As String
&nbsp; &nbsp; Dim conn As ADODB.Connection
&nbsp; &nbsp; Dim rs As ADODB.Recordset
&nbsp; &nbsp; Dim connString As String, SQL As String
&nbsp; &nbsp;
&nbsp; &nbsp; connString = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=C:\yourPath\;Extensions=asc,csv,tab,txt;"
&nbsp; &nbsp; Set conn = New ADODB.Connection
&nbsp; &nbsp; conn.ConnectionString = connString
&nbsp; &nbsp; conn.Open
&nbsp; &nbsp;
&nbsp; &nbsp; SQL = "Select * from [source.txt]"
&nbsp; &nbsp; Set rs = New ADODB.Recordset
&nbsp; &nbsp; rs.Open SQL, conn, 1, 1
&nbsp; &nbsp; If rs.EOF = False Then
&nbsp; &nbsp; &nbsp; &nbsp; rs.MoveLast
&nbsp; &nbsp; &nbsp; &nbsp; LoadText = rs(0)
&nbsp; &nbsp; End If
&nbsp; &nbsp;
&nbsp; &nbsp; rs.Close
&nbsp; &nbsp; Set rs = Nothing
&nbsp; &nbsp; conn.Close
&nbsp; &nbsp; Set conn = Nothing
End Function
</code></pre>To implement: <pre><code class="code-1 nolinks" id="code-20-43080871-2">Sub test()
&nbsp; &nbsp; Dim v As String
&nbsp; &nbsp; v = LoadText()
&nbsp; &nbsp; Debug.Print v
End Sub
</code></pre>I tested this with a 9999 record dummy file and it's pretty fast for me. <a href="https://filedb.experts-exchange.com/incoming/2020/05_w19/1453538/Capture.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2020/05_w19/1453538/Capture.PNG" class="fr-fic fr-dib"></a>
</div>

Capture.PNG

Owner

Bob Schneider

<div>
Awesome. &nbsp;Very nicely done (and no, the, file is on the local machine...not a server.) Thank you both!
</div>

<div>
<div class="content wysiwyg-content">
What is the fastest way to find the value of the last line in a plain text file with records like I am listing below. &nbsp;I want to write it to a variable sLastTriRcd (There are usually thousands of records so a quick and efficient way is necessary.) 
 

<pre><code class="code-10 nolinks" id="code-10-29181215-1">aaC4000000018ff900011909281324072bf8FS
aaC4000000018ff900011909281324072bf8BS
aaC4000000018ff900011909281324072bf8LS
aaC40000000190ac000119092813241243b7FS
aaC40000000190ac000119092813241243b7BS
aaC40000000190ac000119092813241243b7LS
aaC400000001905800011909281324181f96FS
aaC400000001905800031909281324183a95BS
aaC60000000191f700011909281324184bc8FS
aaC60000000191f700021909281324184bc9BS
aaC400000001905800031909281324183a95LS
aaC60000000191f700021909281324185ac9LS
aaC4000000019ffa000119092813243313f0FS
aaC4000000019ffa000219092813243322f1BS
</code></pre>
</div>
</div>

What is the fastest way to find the value of the last line in a plain text file with records like I am listing below.  I want to write it to a variable sLastTriRcd (There are usually thousands of records so a quick and efficient way is necessary.)

(CODE)

Find Last *.txt Line in VB6

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.