Hi,

I have the following to do and appreciate any advice.

1) i have a text file and need to search for a string in the file. if
the string is found, i need to move to the line immediately above the
search string, copy the entire line into excel (2002), and then change
the same to something else in the text file.
2) i also need to accomplish the same for the line below the search
string.

any advice using file pointers that allow to move up and down and text
file, and read and write text without altering the rest of the file?

thanks


--
srkumar
------------------------------------------------------------------------
srkumar's Profile: http://www.excelforum.com/member.php...o&userid=20037
View this thread: http://www.excelforum.com/showthread...hreadid=535479