Thread: Using FileDir and then putting those files in order by date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John Brenner John Brenner is offline
external usenet poster
  
Posts: 9
Default 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
Reply With QuoteReply With Quote