More than one Root Path with max depth

Currently I am using the following code to search for a folder in one directory, namely V:/.
Is it possible to user more than one path in this code with a max folder depth per path?

E.g.

v:/Folder 1/ (only this folder, block subfolder search)
v:/Folder 2/ (only this folder, block subfolder search)
V:/Folder 3/Subfolder/ (only this folder and 1 subfolder, block deeper subfolders)

Please Login or Register  to view this content.

Thank you very much for the reply, I will try this out right away.

One more thing though. Currently the VBA code root path is set as: strRoot = "V:\"
Now the code will search the entire drive.

How can I make the code so that it only searches the following directories with each having their own depth set?

v:/Folder 1/ (only this folder, block subfolder search)
v:/Folder 2/ (only this folder, block subfolder search)
V:/Folder 3/Subfolder/ (only this folder and 1 subfolder, block deeper subfolders)

Again much appreciated.

I've created the following VBA Code

Please Login or Register  to view this content.

What it does: I press a cell in Excel and it should then find the directory and open the folder using my StringID.

Now I have two questions:

Firstly: Have I implemented the different calls to FindFolder the right way?

Secondly: When I execute the above VBA I get the following error: compile error: variable not defined

Attachment 780397

I hope this is my last question.

If my Folder name is "12345" and my StrID is also "12345" its working perfectly!

But when my Folder name is "12345 Hello World" but my StrID "12345" its unable to find my folder.
I cant seem to find anything in the VBA code that's different compared to my original VBA code where I can determine a difference towards just searching a part of my folder name.

Is there anything I can do where it finds my folder with just a part of the folders name?

Again, much appreciated for all the help and learning in the process.