title: Batch search a directory for multiple file names
body: <p>I'll present the practical example first so you can understand what I'm doing. Please note this is on my work computer and network, so I do not have admin rights.</p>
  
  <p>I have a list of items - about 1000 lines, currently in Excel. I normalized it a bit to remove characters that may or may not be included in a file referencing these items. I have access to a directory (via Windows Explorer or Sharepoint), that holds certain documents that may be associated to these items (if we have any information on them). This directory is organized as follows:</p>
  
  <ul>
  <li>A:
  
  <ul>
  <li>\A
  
  <ul>
  <li>\Armadillo
  
  <ul>
  <li>Armadillo.doc</li>
  </ul></li>
  <li>\Army
  
  <ul>
  <li>Army.doc</li>
  </ul></li>
  </ul></li>
  <li>\B
  
  <ul>
  <li>\Bull
  
  <ul>
  <li>Bull.doc</li>
  </ul></li>
  </ul></li>
  </ul></li>
  </ul>
  
  <p>I'd like to run a batch search of some sort to find out if there is a file or directory name that matches a line of text, and then do that for the entire 1000 lines.</p>
  
  <p>For example, say my file has the following lines of text:</p>
  
  <pre><code>Armadillo
  Army
  Baby
  Bull
  </code></pre>
  
  <p>And assume the directory has files that match Armadillo, Army, and Bull, but not Baby.. I'd like the output to detail the file name and location, for example:</p>
  
  <pre><code>Armadillo     A:\A\Armadillo\Armadillo.doc
  Army          A:\A\Army\Army.doc
  Baby
  Bull          A:\B\Bull\Bull.doc
  ...and so on for every line.
  </code></pre>
  
  <p>I only want to read the target directory and report the match (or no match) - no file modification whatsoever. I do not need to look into the actual files, only file names. I also do not want to do anything that could potentially alter the file system. I just want to automate a process that could take forever doing manually, line by line.</p>
  
  <p>I'm sure there are a number of ways to do this with macros in Excel, Find in Files in Notepad++, grep, etc. I've spent numerous hours looking for a solution to this exact problem, but all the solutions seem to be trying to solve a similar problem, but not exact. I'm hoping there is an easy way to do this without altering the file system or causing significant load.</p>