| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| putting a column of names into alphabetical order | Excel Discussion (Misc queries) | |||
| Putting subtotals in $ descending order | Excel Worksheet Functions | |||
| open files in loop with date order | Excel Discussion (Misc queries) | |||
| Putting pages in alpha order? | Excel Worksheet Functions | |||
| putting data in order(?) | Excel Programming | |||
Hybrid Mode
