Multiple Text Replace Across Multiple .txt files in Multiple Folders
Hi! I am looking to basically automate a bunch of find/replace. I have Original/Replacement data in Column A (Orig) and Column B (Replacement) of one sheet in a workbook "Conversion Table" and thgere are 16 text files where I need to use the conversion table. This is a repetitive weekly task. Over time, the contents of the Conversion Table will expand with more rows of original/replacement text (currently there are 21 rows).
Within the 16 *.txt files, I need to FIND the Original text and REPLACE. The *.txt files will also contain plenty of data which won't be replaced.
The 16 *.txt files are data query results being used by a macro to update a report. Before updating the report, this FIND/REPLACE needs to happen.
The 16 *.txt files are located in a folder structure like this:
----Subfolder 1a - 1 file
----Subfolder 1b - 1 file
----Subfolder 2a - 1 file
----Subfolder 2b - 1 file
----Subfolder 5a - 1 file
----Subfolder 5b - 1 file
--Subfolder 6 - 11 files
Every .txt file within the Top Folder can be acted upon by this FIND/REPLACE. Ideally, the FIND matches to total cell contents.
I've seen some posts, tips, which get at some of this (single text replacement across sheets, or using arrays to replace on files in one folder, but I'm not sure how to handle the multi-text, multi-folder scenario...sorry if this is clearly covered elsewhere...
Thanks for any advice!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By nobleprince in forum Excel Programming / VBA / Macros
Last Post: 08-24-2016, 06:33 PM
By rexer231 in forum Excel Programming / VBA / Macros
Last Post: 11-28-2013, 12:03 PM
By gshock in forum Excel Programming / VBA / Macros
Last Post: 02-01-2013, 03:49 PM
By Novice_To_Excel in forum Excel Programming / VBA / Macros
Last Post: 10-02-2012, 01:05 AM
By Royzer in forum Excel Programming / VBA / Macros
Last Post: 07-18-2012, 03:40 PM
By Nav123 in forum Excel Programming / VBA / Macros
Last Post: 06-20-2011, 07:17 PM
By Corben in forum Excel General
Last Post: 03-15-2006, 08:45 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1