P
pk
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...
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...