VBA to delete lines in .txt with multiple specific string.

[BryanAnnang]

Hi I'm new here but I have been browsing here from long time.. I have a new project that needs to alter data on .txt file using excel VBA.

Lets say I have the below Line in .txt and ill be putting the string that I wanted to delete from .txt file in excel range. All lines in .txt file that contains these string should be deleted in .txt file. See below sample... Someone's help would be highly appreciated.

TXT file Excel Range to Delete TXT file output should be:

Sampletext1 ,1111 ,2222 Sampletext1 Sampletext3 ,1111 ,2222
Sampletext2 ,1111 ,2222 Sampletext2 Sampletext4 ,1111 ,2222
Sampletext3 ,1111 ,2222 Sampletext5
Sampletext4 ,1111 ,2222
Sampletext5 ,1111 ,2222

Bryan

 

[BryanAnnang]

TXT file:
Sampletext1 ,1111 ,2222
Sampletext2 ,1111 ,2222
Sampletext3 ,1111 ,2222
Sampletext4 ,1111 ,2222
Sampletext5 ,1111 ,2222

Excel Range to (String to Delete in TXT):
Sampletext1
Sampletext5
Sampletext2

TXT file output should be:
Sampletext3 ,1111 ,2222
Sampletext4 ,1111 ,2222