LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Need Help in cut/paste data from text file to another using excelmacro

Hi,

I have one problem,i have to cut some data from one text file and
paste it to another new text file using excel macro.

eg.

Text file 1 new Text file 2

aaaaaaaa aaaaaaaaa
abcdefghij bbbbbbbbbb
1234567890
aaaaaaaa
bbbbbbbb

the logic should be search text 'aaaaaaa' from bottom of Text file 1
(as this text is repeating in file so i want to search its last
occurence)and cut the data starting from text 'aaaaaa' upto end of
text file and paste it to new text file.
 
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
VBA code to Paste into a specific text file dcozzi Excel Programming 2 March 21st 06 08:01 PM
copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro Steven Excel Programming 1 October 17th 05 08:56 AM
Copying of cell text from one file to paste as cell comments in a 2nd file Wayne Excel Programming 4 March 2nd 05 05:05 AM
importing text file, removing data and outputting new text file Pal Excel Programming 8 February 27th 04 08:32 PM
Bloodhound.ExcelMacro Todd Huttenstine[_2_] Excel Programming 6 December 29th 03 06:39 AM


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

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

About Us

"It's about Microsoft Excel"