Hello,
I am trying to find some completed excel VBA code or a macro that allows me to specify a directory and automatically generates a list in Excel of the folders, subfolders and files - i.e. a full directory tree. I don't wish to use the DOS command for a few reasons. Please can someone advise if they know of any such code or if they have something to hand (don't have time to modify unfortunately so looking for something complete)
Kind Regards,
Raheel
I am trying to find some completed excel VBA code or a macro that allows me to specify a directory and automatically generates a list in Excel of the folders, subfolders and files - i.e. a full directory tree. I don't wish to use the DOS command for a few reasons. Please can someone advise if they know of any such code or if they have something to hand (don't have time to modify unfortunately so looking for something complete)
Kind Regards,
Raheel