How can I get the List of all Files which are in Folder and SubFolder

5 views
Skip to first unread message

Ashu K

unread,
Aug 5, 2015, 12:10:51 PM8/5/15
to Excel VBA Lab
Dear Seniors,

I have a files in Folder and Sub-folder. I want to get the list of all files which are in main folder and Sub-folder with the details of File Name, File Size, File Type, File Created Date, Last Accessed Date, Last Date Modified.


Kindly help.



Thanks & Regards
Ashu Kenith

Ashish Kumar

unread,
Aug 6, 2015, 1:13:48 AM8/6/15
to Excel VBA Lab
Dear Ashu,

Check this.

you need to change your folder location path in module and run the code.



Regards
Ashish Kumar
list-the-files-in-a-folder-and-subfolders.xlsm

Ashu K

unread,
Aug 6, 2015, 11:40:06 AM8/6/15
to Excel VBA Lab
Dear Ashish Sir,

Thanks a lot for your help. I m looking for this only.

Thanks a lot :)

Ashish Kumar

unread,
Aug 7, 2015, 7:45:05 AM8/7/15
to Excel VBA Lab
Dear Ashu,

Welcome....!!



Regards
Ashish Kumar
Reply all
Reply to author
Forward
0 new messages