title: Find specific folder using Excel VBA
body: <p>I've been working on a workbook to be distributed to others and a large part of the code relies on pulling from workbooks saved in a shared sync folder - let's call it "TEETH". </p>
  
  <p>For me, TEETH was installed into this path: <code>"C:\Users\TEETH"</code> but for some others, it's installed <code>"C:\Users\desktop\TEETH"</code> or <code>"C:\Users\My Documents\TEETH"</code></p>
  
  <p>I'm thinking of two solutions
  1. a way that Excel can look through the <code>C:\</code> directory relatively quickly, find the folder then output the path it in a cell
  2. let the user find the folder, then dump the path to a cell</p>
  
  <p>Are the two ways above possible? Or is there a better way?</p>
  
  <p>Thanks!</p>