I need to parse a big txt file (non csv) that has over 700 Mb and so far all my attempts failed with Out of memory error. Initially this file had a smaller size and the lines below worked very well but when this file, with the same structure, increased in volume the method used crashed. Many other approaches based on Line Input, Open file For Binary Access, FSO did not work as well. Any suggestion ?
Dim intFile As Integer, myArr As Variant, myFile As String, s As String
Const delimit As String = "=========================================="

myFile = app.Path & "\BigFile.txt"

On Error GoTo errHandler

  intFile = FreeFile

      Open myFile For Input As #intFile
        s = Input(LOF(intFile), #intFile)
      Close #intFile

    myArr = Split(s, delimit)