ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Using FileDir and then putting those files in order by date (https://www.excelbanter.com/excel-programming/422418-using-filedir-then-putting-those-files-order-date.html)

John Brenner

Using FileDir and then putting those files in order by date
 
I'm using the following 2 lines of code to list files in memory so that I can
use them, but I need the files to be in accending order by date/time stamp.
How can I "Dir" the files in that order?

FileDir = "\\mw\data\SMP-IT\Acceleration_Project\JDA_Docs\Boeing Conversion
Metrics\ANA\"
FilesInPath = Dir(FileDir & "Boeing Conversion Load Metric ANA*.xls")

As always, your help is much appreciated!
TIA,
JB
--
Regards,
John


All times are GMT +1. The time now is 02:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com