Parsing a Text File
I wonder if somebody could point me in the right direction with a query
I have a macro that currently parses a file looking for certain text
and when it finds it copies the string to a given cell in an Excel
I need to adapt this to now look for the line that contains a certain
string of text and then import the following line of text to the cell
in Excel (where I can then manipulate it using text to columns).
Could someone please gie me a hint on how to accomplish this?
My code that needs altering is:
Open FName For Input As Fnum
i = 1
Do While Not EOF(Fnum)
If InStr(1, sLine, "NUE00001 GRAND TOTALS", vbTextCompare) > 0 Then
' This is the bit I need to change to import the line following the
Cells(3, 3).Value = sLine
Thanks in advance,