get folder name
 

What would be the most direct approach to extracting just the last folder
name from "ThisWorkBook.Path".

get folder name
 

Using InStrRev if you're using xl2k or above.

Or looping from the last character to the first looking for the path separator
(\ on windows).

AD108 wrote:

What would be the most direct approach to extracting just the last folder
name from "ThisWorkBook.Path".

--

Dave Peterson

get folder name
 

arrPath = Split(ThisWorkbook.Path, "\")
strParentFldr = arrPath(UBound(arrPath))


Steve



"AD108" wrote in message
...
What would be the most direct approach to extracting just the last folder
name from "ThisWorkBook.Path".

get folder name
 

Thanks,


"Dave Peterson" wrote in message
...
Using InStrRev if you're using xl2k or above.

Or looping from the last character to the first looking for the path
separator
(\ on windows).

AD108 wrote:

What would be the most direct approach to extracting just the last
folder
name from "ThisWorkBook.Path".

--

Dave Peterson