title: VBA - loop through files and batch print most recent
body: <p>I have a working code where the user types the part number and the vba print's all pdf files inside the part number folder.</p>
  
  <p>When there is only one version of the files it is working great, but when a new version is added, I can't figure out how to print only the new version of files.</p>
  
  <p>For example: Part number 1012030. The folder would be "C\User\1012030\"
  then these files are inside:</p>
  
  <p>1000210669_E.pdf (old)<br>
  1000210669_01.pdf (old)                                                                1000210669_02.pdf (new)<br>
  1000210670_01.pdf (old) /1000210670_02.pdf (new)</p>
  
  <p>the first revision is always "_E", then comes "_01"; "_02" and so on..
  the code would look the the first pdf, loop until it finds the newest revision, print it, move to next file and repeat..</p>