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.

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.

On Aug 14, 1:38*am, wrote:
Hi,

I have one problem,i have tocutsome data from onetextfileand
paste it to another newtextfileusingexcelmacro.

eg.

Textfile1 * * * * * * * *newTextfile2

aaaaaaaa * * * * * * * * aaaaaaaaa
abcdefghij * * * * * * * *bbbbbbbbbb
1234567890
aaaaaaaa
bbbbbbbb

the logic should be searchtext'aaaaaaa' from bottom ofTextfile1
(as thistextis repeating infileso i want to search its last
occurence)andcutthe data starting fromtext'aaaaaa' upto end oftextfileand paste it to newtextfile.

..yeah i am new to this macro stuff...please help...thanks..