First I want to make sure that everyone knows that I accept the mistake I made. I have learned from this situation. I just felt that as a new person to this type of thing that I could have been given a chance instead of being pegged as an uncaring individual who cares nothing for the rules or doesn't respect the time and effort of others. Nothing could be further from the truth. While I may not be able to help a lot of people here I certainly try to "pay forward" any help I receive.

GTO: Thank you for your efforts thus far. I am attaching an Excel file that has what I hope is a more concise explaination of what I am trying to accomplish. It contains a sample Input.txt, Output.txt and the Template Excel spread sheet with explaination. Also contained is an Excel spreadsheet that has the vba code I was able to create. It will reference my input and output texts although I am unable to get it to "prompt" me for the files. I had to explicitly state where the files were located as I lack the knowledge on how to get it to use dialogue boxes to prompt me. Where I was getting stuck was the middle part of this process and that is to use the input text as a template to fill in variables.