EXTRACT FILE NAMES FROM A DIRECTORY TO A USABLE TEXT BASED LIST
Posted on 2013-06-20
I tried to do a search and found nothing useful. Our customer sent us a DVD with 5 main directory folders. Each of these 5 folders contains hundreds of subfolders. And each subfolder contains from 1 to as many as 10 part drawing in a standard PDF format. What I'd like to do is extract all the file names in these folders and subfolders and create a list which I can eventually manipulate in Excel to determine if we have ever made this part before. I think I can manage the back half of this little project, if I could just get a little help with creating the text list.
My network is based on WinServer 2003 w/AD. Workstations use XP Pro. I have the most experience using Excel with macros to get where I'm going.
Thanks in advance,