I have tried several codes to get this to work with no success.
I have a folder that has subfolders (A-Z) that will mostly be formatted as "Name - P1111####" however sometimes it will just be "P1111####" ####= random numbers
I need a code that will use the value from a textbox in the userform (in this case "P1111####") search all the subfolders in the main directory and come back and tell me if a folder containing that text was found. Regardless if the name is there or not. *Bonus points for opening the containing folder "Not the file(s)*
If it's not found then advise that well.
Basically, the same way windows search does it when you type info into the search bar it just locates a folder containing that text regardless of extra text.
The folders have been Separated A-Z based on the first letter in the "Name" but really I don't care about searching the "Name" it's mostly there to help verify that the number matches the correct account.
I have a folder that has subfolders (A-Z) that will mostly be formatted as "Name - P1111####" however sometimes it will just be "P1111####" ####= random numbers
I need a code that will use the value from a textbox in the userform (in this case "P1111####") search all the subfolders in the main directory and come back and tell me if a folder containing that text was found. Regardless if the name is there or not. *Bonus points for opening the containing folder "Not the file(s)*
If it's not found then advise that well.
Basically, the same way windows search does it when you type info into the search bar it just locates a folder containing that text regardless of extra text.
The folders have been Separated A-Z based on the first letter in the "Name" but really I don't care about searching the "Name" it's mostly there to help verify that the number matches the correct account.