acessing text files using excel vba
 

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

acessing text files using excel vba
 

push the text !!!

Saludos
Mexico

--
Atte.
?T Francisco T?
http://groups.msn.com/ExcelVbaMacrosOffice
http://groups.msn.com/dadyboy

"El progreso debe ser un movimiento ordenado y racional hacia una meta
fija... y no un torbellino de direcciones falsas y encontradas."