Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.

Nou pe simpatie:
OnutzaGirl la Simpatie.ro

Femeie
23 ani
Galati
cauta Barbat
24 - 51 ani

Mrrrr's Forum (VIEW ONLY)Reguli Inregistrare Login PozeNu sunteti logat. Lista Forumurilor Pe Tematici

Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides /

[EXCEL] VBA - Extract File Name from Path Stored in Cell

TRaP · 2020-11-11T08:45:05Z

And the syntax is: Source: https://stackoverflow.com/questions/1743328/how-to-extract-file-name-from-path.

Pagini: 1

Moderat de TRaP, TonyTzu

TRaP
Moderator
Postari: 960

Function GetFilenameFromPath(ByVal strPath As String) As String
' Returns the rightmost characters of a string upto but not including the rightmost '\'
' e.g. 'c:\winnt\win.ini' returns 'win.ini'

If Right$(strPath, 1) <> "\" And Len(strPath) > 0 Then
GetFilenameFromPath = GetFilenameFromPath(Left$(strPath, Len(strPath) - 1)) + Right$(strPath, 1)
End If
End Function

And the syntax is:

Dim centralizator as String
centralizator = GetFilenameFromPath(Range("O1").Value)

Source:
https://stackoverflow.com/questions/174 ... -from-path

TRaP
Moderator
Postari: 960

Alternative:

Function FileNameFromPath(strFullPath As String) As String

FileNameFromPath = Right(strFullPath, Len(strFullPath) - InStrRev(strFullPath, "\"))

End Function

Pagini: 1

Mergi la