title: VBA - How to get the last modified file or folder in a directory in Excel 2010
body: <p>What I want to do is more complex than selecting a file from a list of files. I will start in a directory, then I want to change to the most recently modified directory. I then want to repeat that process in a sub-directory, and then, inside of that, I want to select the most recently modified excel file and open it.</p>
  
  <p>What is the best approach to do this?</p>
  
  <p>What objects / methods should I be looking into?</p>