title: VBA outputting text file data into excel with mapping table
body: <p>I am trying to create a VBA script which will read Text Files which I have converted from PDF Files and pull out key information following search words.  All the Text Files will be located in a central location C:Work\Text </p>
  
  <p>Within each of these Text Files is information that I would like to pull out and put into columns within Excel.  The search word helps identify the information but the search word may be different in each of the Text Files, so I will need to create a Table of search words.  And once it finds the information in one text file it can move onto the next one it doesn't need to post every instance of the search word appearing in the text file.</p>
  
  <p>Example:
  I am looking for Account Numbers and Amounts </p>
  
  <p>Text File 1: Account Number can be found within the text file by Searching the word "Account Number:" and Amount can be found by searching "Amount:"</p>
  
  <p>Account Number: 1234
  Amount: $10</p>
  
  <p>Text File 2: Account Number can be found within the text file by Searching the word "Account" and Amount can be found by searching "Cost"</p>
  
  <p>Account 00090
  Cost 25</p>
  
  <p>Text File 3: Account Number can be found within the text file by Searching the word "Initial Number" and Amount can be found by searching "Total"</p>
  
  <p>Initial Number 555555555
  Total $90.02</p>
  
  <p>Etc</p>
  
  <p>So essential I would want to create a mapping table that references these Search Words and for it to just bring in the information after the search word .  If a new search word needs to be added I could always just add to the mapping table.  </p>
  
  <p>The output would essential put All the Account Number data into Column A1 and all the Amount Data will go into B1</p>