title: Is it possible to list all the files and folders in a custom directory - excel vba
body: <p>I wanted to know whether any or all of these functions are possible in excel VBA or not:</p>
  
  <ul>
  <li><p>List all the folders and sub folders within a local area (path name). </p></li>
  <li><p>Produce a link so when displayed the user can open it from the spreadsheet.</p></li>
  <li><p>Automatically update on the spreadsheet if user adds or deletes any files or folder/subfolder from a directory.</p></li>
  </ul>