Function to strip...

[SF]

Hi,

I am working with an image/document dataabase for the organization. I am
looking for a function to strip the PATH of a given file (e.g. strip "D:\My
Photo File" from "D:\My Photo File\image001.jpg")

SF

 

[Bill Edwards]

Public Function FileNameOnly(strFullName As String) As String
FileNameOnly = Right(strFullName, Len(strFullName) - InStrRev(strFullName,
"\"))
End Function

 

[SF]

Thank you. It was great.

SF

Public Function FileNameOnly(strFullName As String) As String
FileNameOnly = Right(strFullName, Len(strFullName) - InStrRev(strFullName,
"\"))
End Function

 

[Terry Kreft]

If the file exists then the Dir function will do what you want

i.e.
?Dir("D:\My Photo File\image001.jpg")
image001.jpg


.... otherwise you'll have to use something like the code Bill Edwards has
posted below