title: Last modified date, folder path in a cell
body: <p>I have got a complex problem, it is more complex to explain, but let me start.</p>
  
  <p>I have a path in an excel cell (path leads to a share) and i would like to do it in VBA.</p>
  
  <p>I would like to get the file, which has the shortest last modified date (file was modified last in that folder), but it is not sure how many sub folder the folder I am scanning has.</p>
  
  <p>My Question is, how do I Scan a folder for the files last modified date and how can i scan the subfolders (if there are subfolders) of this folder?</p>