FileSystemObject - What order does it read files

• StefanJ

  SSCarpal Tunnel

  Points: 4713

  More actions

  November 26, 2004 at 4:59 am

  #60448

  I am using the FileSystemObject to step through and load files. It is important that if I have more than one file of the same type that they load in date sequence because subsequent files refresh the data loaded by earlier files.

  Does the FileSystemObject loops through files based on:

  1. the alphabetical name of the file? 

  2. the date/timestamp of the file? 

  3. Totally random?

  4. Other logic?

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  November 26, 2004 at 5:45 am

  #531592

  I believe FSO uses alpha sort.  If you need to use a different sort you will need to use a folder collection.  Loop through all the files in the collection and store the DateLastModified and filename.  Then you can begin to load the files based off your sort for DateLastModified.

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net

• StefanJ

  SSCarpal Tunnel

  Points: 4713

  More actions

  November 26, 2004 at 6:35 am

  #531595

  Thanks for that. Alpha sort is fine, I will get my Oracle colleagues to change the datepart of the file name from ddmmyy to yymmdd