List of files in chronological order

[snb]

use the oneliner:

sub M_snb()
  sn=split(createobject("wscript.shell").exec("cmd /c dir G:\OF\*.csv /b /o-d").readall,vbcrlf)
end sub

The resulting array sn has been sorted by filedatetime.