Microsoft KB Archive/48145
Excel: FILES() Function Returns Files in FAT Order
The information in this article applies to:
- Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
The Excel FILES() command does not sort files by date, alphabetically, or by file size. It sorts based on the way files are listed in the file allocation table (FAT). An identical list can be obtained by executing a DOS-level directory listing of the same directory.
Additional query words:
Issue type :
Last Reviewed: March 15, 1999