get folder name

  • Thread starter Thread starter AD108
  • Start date Start date
A

AD108

What would be the most direct approach to extracting just the last folder
name from "ThisWorkBook.Path".
 
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).
 
arrPath = Split(ThisWorkbook.Path, "\")
strParentFldr = arrPath(UBound(arrPath))


Steve
 
Thanks,


Dave Peterson said:
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).
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Image on userform from picture in a worksheet 2
Consolidation Function VBA 6
Remove end folder from path found with ThisWorkbook.Path command ? 9
open all workbooks in a folder 3
Get file name to open from cell 2
Creating folders using VBA 2
Error 5 on Shell Command 12
Verifying path fails for no apparent reason..Clueless 2

Back
Top