Hello, can someone help me please?

I am using VBA in Excel XP with Windows 2000.

I need to be able to return the full path to a
subdirectory given only the drive and the directory name
sought (i.e. not the path in between).

For example, I know the drive is: \\cdl\ofl\users\

I know the subdirectory I want is named: Aug03

I need code to return the full path to the subdirectory
which may be something like:

\\cdl\ofl\users\msm\work\losses\Aug03\

or like: \\cdl\ofl\users\ldw\fieldwork\Aug03\

There are two to four files in the target directory and
their names are dynamic.

Your example code would be most appreciated...thanks in
advance...