excelismagic
asked on
Search the selected directory and list all folders and files created from 3 days ago until today.
I need help,
i need VBA to go through all folders and sub-folders of selected directory and list all folders and files which their creation date falls between now and 3 days ago.
thanks vert much.
i need VBA to go through all folders and sub-folders of selected directory and list all folders and files which their creation date falls between now and 3 days ago.
thanks vert much.
ASKER
thanks Rgonzo,
but it return error 53 File not Found.
although, i have folders that created just now and its name should be listed in excel. but i get the error.
but it return error 53 File not Found.
although, i have folders that created just now and its name should be listed in excel. but i get the error.
What is the value of strtext at the error ( Which line as well)
ASKER
it was giving error in line If oFS.GetFile(strtext).DateC reated > Date - 3 Then which i solved it but removing the long named files and the error disappeared.
thanks.
how do i put this now into excel sheet,
i used Debug.Print strFilesList and it listed the details into immediate window.
but i dont know how to put the details instead of immediate window to activeworksheet.
thanks.
how do i put this now into excel sheet,
i used Debug.Print strFilesList and it listed the details into immediate window.
but i dont know how to put the details instead of immediate window to activeworksheet.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks very much Rgonzo.
pls try
Open in new window