Sequence of subfoldres (1 Viewer)

I have a "main" folder, in which there are subfolders.

I have VBA to get the name of every subfolder present in the main folder, but I wondered if there is a way I can get the names of the subfolders returned in "Date Created" sequence, instead of alphabetical sequence?

I know I can write VBA to recover the folders' creation dates into an array, then sort the array, but I wondered if there was any way to modify an attribute in the main folder (similar to clicking on Date Created in Windows Explorer) to achieve my aim?

I've tried using Watch to examine the main folder's attributes when Dim'd as Folder or Dim'd as Object, but can't find anything which looks like it could be modified to achieve my aim.

Any ideas?

I don't think there is any specific order that files/subfolders are returned. If they are coming back in alphabetical order that may be a coincidence.

adjusting the explorer view by sorting is specific to explorer and again, I don't think would have any impact on how files/folders are returned.

Think you will have to go the array route (or populate an adodb recordset)

I spent some time on a similar task recently and can confirm that specifying a sort order is not possible.

It's probably a lot easier to populate a table and let Access sort it with a query, rather than going through the trouble of sorting an array.

You might get some ideas here: https://www.access-programmers.co.uk/forums/showthread.php?t=294416&highlight=attributes or https://www.access-programmers.co.uk/forums/showthread.php?p=1537880

It depends on what you really need. You could consider the DOS Dir command with parameters


You can direct the output to a file that you could import to Access

eg
DIR /s/b *.jpg >c:\users\bob\documents\BobFile.txt

Thanks to all for the thoughtful replies.

As it happens I already have a User written sort function in VBA, but it seemed a bit extreme to deploy it.

I often find I've spent hours coding and testing VBA, only for someone to say "Why didn't you just use the 'Wibble' function?".

Looks like for once the investment in coding paid off!