hello,
I seek for macro to create the whole data as what shows in the sheet1,2 . my directory is D:\FOLDER . This directory contains many folders and subfolders and different extensions files .
sheet orginal is before run the macro .
in sheet1 when select fro D2 should create the names folders and subfolders and brings the files under folder name & subfolder name with create the hyperlink whether folders or files names to open it.in sheet2 if select D2,E2 together then should brings the files based on modified date
last thing the result in sheet1,2 should be in sheet original .
Bookmarks