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