Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel (xls) files spontaneously converting to text files | Excel Discussion (Misc queries) | |||
Linking to text files in Excel | Excel Discussion (Misc queries) | |||
Macro to open *.dat files and save as .txt (comma delimited text files) | Excel Programming | |||
Importing text files into Excel | Excel Discussion (Misc queries) | |||
Password prompt for acessing a workbook | Excel Programming |