swaggerbox
11-28-2012, 05:57 AM
I have multiple text files (*.txt) located in "E:\Test". I need to replace the text strings that contain the following terms with their corresponding replacements (see below)
"EXAMPLE_AA" replace with "AA\EXAMPLE_AA"
"EXAMPLE_CC" replace with "CC\EXAMPLE_CC"
"EXAMPLE_EE" replace with "EE\EXAMPLE_EE"
"EXAMPLE_GG" replace with "GG\EXAMPLE_GG"
"EXAMPLE_HH" replace with "HH\EXAMPLE_HH"
"EXAMPLE_JJ" replace with "JJ\EXAMPLE_JJ"
"EXAMPLE_KK" replace with "KK\EXAMPLE_KK"
"EXAMPLE_RR" replace with "RR\EXAMPLE_RR"
"following materials in EXAMPLE_" replace with "following materials in UU\EXAMPLE_"
There may be multiple instances of these terms in a single text file. I have only limited VBA experience so I would appreciate any help that I can get to get this started.
I need to do this in Excel since I'm not very familiar with MS Word.
"EXAMPLE_AA" replace with "AA\EXAMPLE_AA"
"EXAMPLE_CC" replace with "CC\EXAMPLE_CC"
"EXAMPLE_EE" replace with "EE\EXAMPLE_EE"
"EXAMPLE_GG" replace with "GG\EXAMPLE_GG"
"EXAMPLE_HH" replace with "HH\EXAMPLE_HH"
"EXAMPLE_JJ" replace with "JJ\EXAMPLE_JJ"
"EXAMPLE_KK" replace with "KK\EXAMPLE_KK"
"EXAMPLE_RR" replace with "RR\EXAMPLE_RR"
"following materials in EXAMPLE_" replace with "following materials in UU\EXAMPLE_"
There may be multiple instances of these terms in a single text file. I have only limited VBA experience so I would appreciate any help that I can get to get this started.
I need to do this in Excel since I'm not very familiar with MS Word.