Fellow Forum Members,
Can someone out there please help me out with a VBA 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 VBA 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.
Can someone out there please help me out with a VBA 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 VBA 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.