Good Evening,

I wonder if somebody could point me in the right direction with a query
I have?

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
file.

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
matching row....

Cells(3, 3).Value = sLine

End If


Thanks in advance,

Richard