对于选择性循环excel vba中的目录，哪种方法最好

IO want to check all the edf files at the path main directory/ABC*/Y/XY*/*.edf and then check the files for a specific phrase and if found check for another phrase and so on and then fill the data in the spreadsheet. I have tried to achieve this through three methods but was stuck at some point in every method. Is it possible for anyone of you to go through the code and tell me where I am wrong and which the best approach if any. As the misconception created by my previous questions I don't want anyone to write code for me. I've started working on vba for three days and I've 5 days to complete this project. That's why I'd be grateful if anyone could have a look and tell me where I'm going wrong.IO want to check all the edf files at the path