Sorted directory listing (97 / 2002)

Topic

New Reply

I wrote an application that uses the Dir() function to find all the JPG files in a folder and does some processing on them. It does its job, but now I find that it’s important to process the files in alphabetic order. Help for Dir() states that Dir() returns the files in no particular order, and its up to the programmer to sort the list manually using an array. I think I can do this, but it seems a bit clunky, and was wondering what other people do when confronted with the same requirement. Comments?

PS. I searched Google etc for a class module that would do this task, but came up empty. Does anybody have some code that can be dropped into an existing application that I could use? Thanks.

Reply | Quote

Replies

Why don’t you search on google to find SORT.

An alternative is to append these filename entries to a table, then use a query or SQL code to read thru the table in filename order.

Reply | Quote

Why don’t you search on google to find SORT.

An alternative is to append these filename entries to a table, then use a query or SQL code to read thru the table in filename order.

Reply | Quote

This newsgroup post demonstrates how to use FileSystemObject from the Scripting library together with a disconnected ADO recordset to sort the directory listing.

More ideas in the thread starting with post 343243.

Reply | Quote

This newsgroup post demonstrates how to use FileSystemObject from the Scripting library together with a disconnected ADO recordset to sort the directory listing.

More ideas in the thread starting with post 343243.

Reply | Quote

If interested, see attached sample database (A2K format). Form frmListFiles has a listbox that lists files with specified file spec, from specified folder, in alphabetical order. A callback function (LoadFileList) is used to populate list; the file list is generated using DIR function (see GetFileList function); the file list is sorted using a standard-issue QuickSort (see QuickSortArray sub). These functions performed efficiently in testing, even with large numbers of files in a directory. When form opens, default file spec is “C:*.*”, this can be modified to suit other purposes.

HTH

Reply | Quote

Thanks Mark. That fits the bill exactly.

Reply | Quote

Thanks Mark. That fits the bill exactly.

Reply | Quote

If interested, see attached sample database (A2K format). Form frmListFiles has a listbox that lists files with specified file spec, from specified folder, in alphabetical order. A callback function (LoadFileList) is used to populate list; the file list is generated using DIR function (see GetFileList function); the file list is sorted using a standard-issue QuickSort (see QuickSortArray sub). These functions performed efficiently in testing, even with large numbers of files in a directory. When form opens, default file spec is “C:*.*”, this can be modified to suit other purposes.

HTH

Reply | Quote