Building Multiple .txt Files From An Original .txt File With Specified Find and Replace

[kevenson]

Let me start by explaining the process of what I am trying to do

I have an original text file and I am trying to build many (about 650) text files with a few minor changes to each one
The changes include renaming each file with a specified file name and replacing some of the words/data in text file

In the uploaded workbook I have laid out two tables on sheet1 and sheet2 that help illustrate what I am trying to do
I have also uploaded the base .txt file that I am using.

[MaczaQ]

Hi,

lack of explanation.

Source data from column H (3) appears very often in txt file (like '3', '3060', '315' etc.)

[kevenson]

I am aware of how often the data in H appears, I meant for the uploaded chart just to be a sample of what it could replace. The exact replacements that I want to be making will be much more specific e.g. BV1212, CL1212, FC1212.

Let me better explain how I am trying to make this work, Take sheet 2 for example, The original/base file name is located in B4, B5-B12 are a list of what i would like the new file names to be. F4, G4, H4... are the words I would like it to search in the file. When the code finds an instance, lets say, F4 which is "AG_TIME", it will replace "AG_TIME" with "AG_TEMP" and save the file as td5002.txt

I'm sorry this isn't terribly concise I'm quite new to the excel and vba game