Hi all,
Today my question is how to search a parent directory to look for sub folders named 'RAW'. I already have a code that works when you point directly to the raw folders but i have many different raw folders to perform the action too. Our folder structure is a parent directory with a date when the projects were completed and then is separated into a sub folder for each project(approx 60 projects). In each projects folder the is the sub folder named 'RAW'.
Dubbbdan
Two things:
[1] Open up your VBE, go to the References menu and, if it is not already done, click the checkbox for an item called Windows Script Host Object Model. The code below will not work without this being done.
[2] Paste the following code into a blank module and run it. You will be asked to kick the process off by picking a folder. The output (which will show in Column A) will be a listing of all subfolders, and their subfolders, and their subfolders and so on of the folder that you picked. You can then filter for all those folders with "RAW" in the name.
_____________________
Please Login or Register to view this content.
[1] If this reply was helpful, click the star to the left.
[2] If this reply answered your question, mark this thread as [SOLVED].
Last edited by Dimitrov; 10-08-2013 at 01:19 AM.
Hi, Dimitrov,
are you sure about your 1.) as the code uses Late Binding?
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
@HaHoBe: You are right. I am using late binding. I switched it up halfway through writing the code and forgot about that.
@dubbbdan: It won't hurt if you do not perform action [1] in my reply above; however, if you have already done it, no worries. I believe the code should run (either way). Props to HaHoBe for pointing that out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks