Script for Find Replace Operation

[binar]

Fellow Forum Members,
Can someone out there please help me out with a scrpt that will do the following:

I have five TEXT files, and each of these TEXT files contains three different text entries. What I need is an EXCEL script that will find and replace one set of text entries with three different text entries (ALL IN CAPS). Is it possible to write a script that will enable Excel to open each text file (located in specified path) then do a Find/Replace operation, and then close the TEXT file?

This is a basic example. In reality I have 50 text files each one containing three text entries I need changed to something else. I'm currently doing this find/replace work manually and I would like to automate it. Any help will be greatly appreciated. Thanks in advance.

[binar]

Can anyone please help?

[Chippy]

It sounds like you don't need a VBA solution. If so, try this great search and replace utility - http://www.inforapid.de/html/searchreplace.htm. It's quite old (2003), but I've used it for several years and not bothered to find a more recent utility to do the same job.