'#####serach big file (ADODB.Recordset) →it is fast#####
Sub searchLineFromText()
Dim CN As ADODB.ConnectionDim RS As ADODB.Recordset
Dim rsList As Collection
Dim tempStr As String
Set CN = New ADODB.Connection
Set rsList = New Collection
CN.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=D:\work_forfree\20160313_for_vba_open_bigfile\;" & _
"Extended Properties='text;HDR=NO;CharacterSet=65001'"
'FMT=Delimited
Set RS = CN.Execute("SELECT * FROM testfile.txt WHERE F1 LIKE '%ERROR%'")
Do Until RS.EOF
'Debug.Print RS.Fields(0); RS.Fields(1); RS.Fields(2)
tempStr = RS.Fields(0)
rsList.Add tempStr
RS.MoveNext
Loop
Set RS = Nothing
Set CN &