title: Excel : File Open Dialog in VBA that is set to Detail View and sorted by Date Modified
body: <p>I have tried to Google for this quite extensively but I hope someone here can come up trumps.  </p>
  
  <p>As a lot of people ( I imagine ) would like, I want to spawn a File Open dialog box from Excel ( no problem with that using GetOpenFilename ).   </p>
  
  <p>I think I am trying to achieve the same thing most people want when they open up a dialog, they want to choose a file, and normally this is the latest one of that type?</p>
  
  <p>So say I have a C:\Temp dir full of .piv files and I want to grab the last created.  I have to open the dialog, change to details and then click the Date Modified column and then this will be the view and set up I want.    </p>
  
  <p>I have to do this EVERY TIME, as do the users.  Is there any way of setting the sort and the view type from Excel VBA.</p>
  
  <p>The Chapter 9. stuff from Professional Excel Development gives me some hope, but doesn't get me all the way there.</p>
  
  <p>So strange seeing as it must be a common thing for people to want to do?</p>