Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel (xls) files spontaneously converting to text files Be-jamin Excel Discussion (Misc queries) 0 November 18th 08 05:31 PM
Linking to text files in Excel Longtime listener first time caller Excel Discussion (Misc queries) 2 April 23rd 07 11:38 AM
Macro to open *.dat files and save as .txt (comma delimited text files) [email protected] Excel Programming 2 November 30th 05 05:50 AM
Importing text files into Excel Christopher Anderson Excel Discussion (Misc queries) 2 December 4th 04 05:57 PM
Password prompt for acessing a workbook «Â¤Æ¡­ Excel Programming 1 October 2nd 03 12:35 PM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"