title: Using Excel to open latest version of a File (with different name)
body: <p>I need to create a macro to open another excel file (so I can copy the contents). this file is regularly refreshed and I need take the data from the latest version of this file. Each file has a variation in the name as the latest version has an larger version number (not incremental). They will also have a date which I need to factor in.</p>
  
  <p>Here is an example of the files.</p>
  
  <p>Saved 16/03/2016 at 4.58pm</p>
  
  <p>"Daily Global Model Extract_GL_FM_2016_03_16_165819.xls"</p>
  
  <p>Saved 16/03/2016 at 5.58pm</p>
  
  <p>"Daily Global Model Extract_GL_FM_2016_03_16_174817.xls"</p>
  
  <p>I need something robust which will deal with the change in document name. </p>