title: Excel-VBA Find a pdf file given a path
body: <p><strong>Problem:</strong><br>
  I need to know what files have been placed in a series of folders. I'd like to catalog which files are there in each folder and be able to do check this whenever I want without having to manually go into each folder. A sort of "syncing" of multiple files from different directories to a centralized catalog so that if I delete a file from a folder then the catalog will reflect the change.</p>
  
  <p>I was hoping Excel could help with this. In short I want to be able to do this: </p>
  
  <pre><code>Filename     FilePath                     Exists
  
  abc_4.23.11  C:\4-23-11\abc_4.23.11.pdf   *True/False*
  </code></pre>
  
  <p><strong>Details/Assumptions:</strong>  </p>
  
  <p>The main directory won't change for a file. So File "abc.pdf" will always be in the same folder.  </p>
  
  <p>Let's assume Folder 1 has the following convention:  </p>
  
  <p>Folder Name: <code>mm-dd-yy (i.e 4-30-11)</code></p>
  
  <p>Contents of Folder 1: A series of other subfolders, we'll call these using letters so Folder A, Folder B, Folder C...Folder Z.  </p>
  
  <p>Inside each subfolder is a pdf file which I need to confirm that it is there.</p>
  
  <p>Let me know if there's any questions.</p>
  
  <p>Thanks a million!</p>