VBA to check if a folder name contains a specific word

[lynnsong986]

Hello,

I have a file structure like:

a main folder\many sub folders\excel files. What i need to do is to loop through all sub folders and if a sub folder name has "waiting" as part of its name, then open all excel files in it.

can someone please help me with this line of code, the underlined part is wrong and needs correction

Do While Not SubFolder = "" and not SubFolder.name contains "waiting"

thank you so much in advance.

 

[mumps]

Sorry - misposted.