title: Sorted list of file names in a folder in VBA?
body: <p>Is there a way to get a sorted list of file names of a folder in VBA? Up to now, I arrived at</p>
  
  <pre><code>Dim fso As Object
  Dim objFolder As Object
  Dim objFileList As Object
  Dim vFile As Variant
  Dim sFolder As String
  
  sFolder = "C:\Docs"
  
  Set fso = CreateObject("Scripting.FileSystemObject")
  Set objFolder = fso.GetFolder(sFolder)
  Set objFileList = objFolder.Files
  
  For Each vFile In objFileList
      ' do something '
  Next vFile
  </code></pre>
  
  <p>but it is crucial to be sure the processing order of the for loop is determined by the file names...</p>
  
  <p>Any help appreciated!</p>