[Ianm1]

I need to read an import text file via VB or VBA only select lines that start with a number and write those lines to a new file

I have looked at Streamreader/streamwriter but cannot understand the way to select the line

[raziel_]

streamreader/writer is VB.NET. but there is a tutorial about reading text file line by line in our tutorial section under vb6 section

[parbipin]

This is not the complete code and also not tested. It reads a line and stores it in variable tLine. You would then need to apply your logic around if you wanna use that line or not. Also, How do you wanna use it.

Dim FileNum As Integer, tLine As String, LogFileName as String

LogFileName = "Complete path to your Text File"

    FileNum = FreeFile ' next file number
    Open LogFileName For Input Access Read Shared As #FileNum ' open the file for reading
    Do While Not EOF(FileNum)
        Line Input #FileNum, tLine ' read a line from the text file
    Loop ' until the last line is read
    Close #FileNum ' close the file

Hope it helps!!!!