title: VBA, FileSystemObject, Windows sort order
body: <p>I'm tying to make something in VBA that will basically list all the files in one or more directories starting from a root folder. Long story short, I'm using filesystemobject to run through all of the folders and then getting all the files in those folders. Moving to the next folder, etc. </p>
  
  <p>The problem I'm running into is that I need to spit out my data (onto a sheet) in the same folder sort order as one might find in Windows. I know this isn't a fixed concept per say, so here's a quick example, as it's displayed in Windows(for me): </p>
  
  <p>Windows Sort Order: </p>
  
  <pre><code>FolderTest\000
  FolderTest\0
  FolderTest\0001
  </code></pre>
  
  <p>Not too surprisingly, when using FSO it returns the sub folders in a different (perhaps more logical) order: </p>
  
  <pre><code>FolderTest\0
  FolderTest\000
  FolderTest\0001
  </code></pre>
  
  <p>I was hoping someone might have an idea of what one could do to get this to be resorted as it's displaying in Windows. This is just an example obviously, the files could be named anything, but it certainly seems to behave a lot better with alpha characters in the name. I'm not necessarily married to using FSO, but I don't even know where else to look for an alternative. I know I could potentially resort these in an array, but I'm not sure what kind of wizardry would be required to make it sort in the "proper" order. For all I know, there's some method or something that makes this all better. Thanks in advance for any help!</p>