Find a directory
 

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\

Can something like "FileSearch" be adapted in some way? I
tried this but it failed for me.

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