.TXT Batch replacing Macros

[afzalw]

I am looking for a Macro that replace my text files. It should be able to search a same work from all txt files and replace it with a different word for each file. For example I have same word "TEXT" in all my 1000 files, I want to replace this word in each file by a different word like "TEXT1" for first file, "TEXT2" for 2nd file, TEXT3" for 3rd file...."TEXT1000" for file.

I don't want to to go in each file and find this word and replace it.I have tried software like ReplaceText2.2, Power GREP, Advance Replace tools batch editing software but nothing worked for me. If anyone can help me building this Macro if its possible in excel.

I'll try to further simplify the statement.
I have 1000 files.
File 1 Search "11111" Replace it with "0.324"
File 2 Search "11111" Replace it with "0.932"
File 3 Search "11111" Replace it with "0.842"
File 4 Search "11111" Replace it with "0.642"
File 5 Search "11111" Replace it with "0.652"
.
.
.
File 1000 Search "11111" Replace it with "0.442"
Now you see all the search terms are "11111" but replace terms are different for each file.

 

[Macropod]

If it was simply a matter of incrementing a counter, you could possibly do this without a reference data file. However, your 'simplify' statement shows that it really isn't so simple. For that, you'll require a file with the replacement data strings, all in the correct order - with the corresponding filenames as well, if you need to ensure which fiile gets what revision. What do you propose to use for that?

 

[afzalw]

This problem has been solved on another forum here.

 

[Macropod]

For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters

 

[afzalw]

Thanks, very informative I will try to follow these etiquette in future.