title: Excel VBA retrieve "Last Modified By" for a list of filepaths in a spreadsheet (ideally as a function?)
body: <p>This is my 2nd attempt at writing this question and hopefully I can make it make more sense this time around!</p>
  
  <p>Basically I have created a macro that scan any given folder (and sub-folders within it) and list filepath/filename of every file (using FSO) and, through a series of Excel formulas, test whether the filenames adhere to a specific naming convention. So far so good.</p>
  
  <p>What I now need is, for filenames that have failed to meet the required convention, to identify the user ID of the person who last saved the file (i.e. last modified BY). </p>
  
  <p>Some of these folders contain hundreds of thousands of documents and therefore rather than building this functionality into the existing macro and potentially significantly slowing performance, I want this to run separately, after I have extracted the fails into another sheet/workbook. </p>
  
  <p>If this can be created as a function this would be awesome but any solution is appreciated. </p>
  
  <p>Hope that makes sense.</p>
  
  <p>Thank you :)</p>
  
  <p><a href="https://i.stack.imgur.com/AWqjQ.png" rel="nofollow noreferrer">How the data is structured</a></p>