alstubna
04-22-2012, 01:56 PM
Hi all!
I did search for this and did find a few examples but none does exactly what I need. I tried using the closest example to what I want and modifying it but I'm not having much luck.
Cell A2 is a data validation list of directory names.
Cell B2 is the full path to the directory selected from the drop down list. For example: C:\XrayCalibration\Standards
What I would like to do is list all the file names from the directory/path shown in cell B2 starting in cell E2 and have the directory name listed starting in cell D2.
Any help is much appreciated.
Al Stubna
I did search for this and did find a few examples but none does exactly what I need. I tried using the closest example to what I want and modifying it but I'm not having much luck.
Cell A2 is a data validation list of directory names.
Cell B2 is the full path to the directory selected from the drop down list. For example: C:\XrayCalibration\Standards
What I would like to do is list all the file names from the directory/path shown in cell B2 starting in cell E2 and have the directory name listed starting in cell D2.
Any help is much appreciated.
Al Stubna