Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the last modified directory and file
Hi,
I am working on a project in which I want to find the latest directory and the lastest file in that directory. G:\hweng\ATCA\Compliance\EMC\In house scans\3-1-05\*.xls Till "In house scans" the directory path is fixed. The 3-1-05 directory name keeps on changing every month. I have no idea as to how to find the lastest or last modified directory and last modified excel file. Is there any function in VBA that will find the latest directory and file..... Any help on this will be greatly appreciated. Regards Shilpa |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
finding internal links in excel directory | Excel Discussion (Misc queries) | |||
date file modified | Excel Discussion (Misc queries) | |||
file save error: the file or directory cannot be created | Excel Discussion (Misc queries) | |||
Detect if a file is in use or being modified | Excel Programming | |||
Finding name of last user who modified Excel Spreadsheet | Excel Programming |