Where are we starting? I mean, how much do you already know about VBA? Do
you, for example, already know how to find text in a character string but
you've never worked with text files in VB before? Or have you written lots
of macros in VBA/Access but never in VBA/Excel? Or what? I ask because most
of this is kind of newbie stuff, and there's nothing at all wrong with
newbies asking questions but I don't want to explain the parts that you
already knew how to do :-).

--- " wrote:
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' up to the end of
text file and paste it to new text file.