Get folder name from path in Excel VBA

Question

I didn't find through searching in internet simple solution for this purpose which can be quickly integrated into my code. I propose my solution.

Sharunas Bielskis · Accepted Answer · 2020-03-21 10:46:31Z

2

As this function from time to time, I need in my projects I decided to create a separate function for it. The code of it is below:

Function GetFolderNameFromPath(folderPath As String) As String

Dim lastPathSeparatorPosition As Long, folderPathLength As Long, folderNameLength As Long

lastPathSeparatorPosition = InStrRev(folderPath, Application.PathSeparator)
folderPathLength = Len(folderPath)
folderNameLength = folderPathLength - lastPathSeparatorPosition
GetFolderNameFromPath = Right(folderPath, folderNameLength)

End Function

answered Mar 21, 2020 at 10:46

Sharunas Bielskis

1,2172 gold badges17 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ron Rosenfeld · Accepted Answer · 2020-03-21 22:13:41Z

2

You can actually do this with a single line of code:

Function GetFolderNameFromPath(folderPath As String) As String
    GetFolderNameFromPath = Split(folderPath, Application.PathSeparator)(UBound(Split(folderPath, Application.PathSeparator)))
End Function

answered Mar 21, 2020 at 22:13

Ron Rosenfeld

62k7 gold badges35 silver badges71 bronze badges

2 Comments

Sharunas Bielskis Over a year ago

A nice solution to split the path into an array. Personally I prefer several code lines with meaningful variables instead of one long code line with several methods in it.

Ron Rosenfeld Over a year ago

You'll find that the Split method can be very useful in returning portions of delimited strings.

Collectives™ on Stack Overflow

Get folder name from path in Excel VBA

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related