Set multiple strRoot paths under one strRoot

Currently I am using the following VBA code in Excel.

When executed the code searches the cell's value on strRoot = "V:\" and opens the folder if the result is found.

Please Login or Register  to view this content.

Is it possible to set strRoot to a few semi fixed paths instead of the complete V:\ drive and all its subfolders?

E.g. only search the following paths:

V:\FOLDER 1\Subfolder 1\ (This path 2 folders deep)
V:\FOLDER 2\ (This path 1 folder deep)
V:\FOLDER 3\Subfolder 1\Subfolder 2 (This path 3 folders deep)

I don't want the VBA to search a 1000+ files and folders but only search in these selected paths.

Try:

Please Login or Register  to view this content.

Artik

Much appreciated, but I dont think it does what I want. I tried the code but it still searches all Subfolders in a linear way.

V:\FOLDER 1\Subfolder 1\Subfolder 2\Subfolder3\Subfolder4
V:\FOLDER 2\Subfolder 1\Subfolder 2\Subfolder3\
V:\FOLDER 3\Subfolder 1\Subfolder 2\Subfolder3\Subfolder4\Subfolder5

Example: If my StringID (the value which is used to search for my folder) is inside V:\FOLDER 2\Subfolder 1 the command still searches in a linear way through all Subfolders under FOLDER 1 (so Subfolder 1 to 4) before searching the Subfolders under FOLDER 2. What I want is the search doesnt go beyong Subfolder 2 under FOLDER 1 (see depth in RED).

Is there another way to do this, or set lMaxLevel = 2 'Maximum depth of subfolders per folder under my V:\ drive

I've done some extensive testing and searching online for solutions but I still haven't been able to figure the above out.
Anyone else who could assist me in my issue or send me in the right direction?

Originally Posted by Nebucanezars

... who could ... send me in the right direction?

Use maybe "FileDialog" to dictate/force the choice of a particular directory nesting, e.g.:

Please Login or Register  to view this content.