On Apr 20, 2:22*pm, John W. Vinson
wrote:
On Tue, 20 Apr 2010 09:04:46 -0700 (PDT), mcnews
wrote:

how to fill list box with file names sorted by date - newest first.
tia,
mcnewsxp

Look at the VBA help for the Dir() function, and use a loop to fill a Table.
Use that table (or a query based on the table) as the Row Source for the
listbox.
--

* * * * * * *John W. Vinson [MVP]

so the file names have to go into a table before i can sort them. no
way to let the dir() command do it. ok, i get it.