Batch delete all text that appears between NAME#1 and NAME#2 in text file.

[sr1111]

Batch delete all text that appears between NAME#1 and NAME#2 in a text file.
The VBA should begin after the NAME#1 data ends and come to an end before the NAME#2 line.

An example of the input and output of a text file is below:

Input text.text file	Output text.text file
1. How to copy text in rows betwen numbers from a text file. How to copy text in rows NAME#1 betwen numbers from a text file. How to copy text in rows betwen numbers from a text file.% content1 content2 content3 NAME#2 How to copy text in rows betwen numbers from a text file.	1. How to copy text in rows betwen numbers from a text file. How to copy text in rows NAME#1 betwen numbers from a text file. How to copy text in rows betwen numbers from a text file. content3 NAME#2 How to copy text in rows betwen numbers from a text file.
3. How to copy text in rows NAME#1 betwen numbers from a key:1# text file. How to copy text content1 content2 in rows betwen NAME#2	3. How to copy text in rows NAME#1 betwen numbers from a key:1# text file. NAME#2
5. How to copy key:1# text in rows betwen numbers from a text file . How to copy text in rows betwen numbers from a text file NAME#1. How to copy text in rows betwen numbers from a text file How to copy text in rows betwen numbers from a text file How to copy text in rows betwen numbers from a text file 8090. How to copy text in rows betwen numbers from a text file NAME#2	5. How to copy key:1# text in rows betwen numbers from a text file . How to copy text in rows betwen numbers from a text file NAME#1. How to copy text in rows betwen numbers from a text file How to copy text in rows betwen numbers from a text file 8090. How to copy text in rows betwen numbers from a text file NAME#2

 

[Dan_W]

OK. And how far have you managed to get?

 

[sr1111]

OK. And how far have you managed to get?

None.

 

[Dan_W]

That's a shame. Most people, when they come to this forum asking for help/guidance, will usually at least throw in a 'please' or a 'thank you' rather than simply listing out their requirements.
But don't worry - I'm sure someone bored and willing to do your bidding will come along to code it for you soon.

 

[sr1111]

What does it actually mean "how far have you managed to get?"
I thought it is about the excel results I tried to get by myself. So replied that way.

 

[Dan_W]

It means "How far have you managed to progress in coming up with a coded solution?"
"None" would seem to indicate that you've done nothing in that regard.