Macro to replace the data

[toravietl]

Hi,

I have nearly 300 text files in one path(C:/Documents).I need a macro to replace the some content present in all the 200 text files at a time.In each text file I need to replace 'Unitedstates' name as USA and 'UNitedKingdom' name replace it as UK in all 300 files.So when I run macro it will replace the values in all 300 files.any one can help me on this.

[Crooza]

Give this a go. It worked on a few test runs I ran. Change the bits in red as required

Please Login or Register  to view this content.

[apo]

Deleted......

[Crooza]

Try this small improvement. It will save 300 files being open on your desk top

For the purists there is a bit of rubbish in this, commented lines that need to be removed and variables declared and not used. I didn't tidy it up because I - well I just didn't. You know what it's like when you change one macro to do the work of another, you get a bit sloppy and take short cuts.

Please Login or Register  to view this content.

[toravietl]

Hi Crooza,

Thx for the code.It is adding " symbol also in files data when I run macro and one more issue issue is after run it should display msg like number(count) of files replaced or message like replacing done.Otherwise I need to check every time like data replaced or not.

[Crooza]

Where is the " being added? Is it at the beginning of the file or the end of the file or randomly throughout? Is it replacing the text as requested?

add msgbox("Finished") to the end of the code if you want a message box

see revised version. I'm not getting the " anywhere

Please Login or Register  to view this content.