如何仅从文件的完整路径获取文件名? MY path - C:\Documents and Settings\Arshad\My Documents\ravi.txt 看看这个: Retrieve Filename without Path or Extension. 以下是上述链接的功能: Public Function GetFileName(
MY path - C:\Documents and Settings\Arshad\My Documents\ravi.txt看看这个: Retrieve Filename without Path or Extension.
以下是上述链接的功能:
Public Function GetFileName(flname As String) As String
'Get the filename without the path or extension.
'Input Values:
' flname - path and filename of file.
'Return Value:
' GetFileName - name of file without the extension.
Dim posn As Integer, i As Integer
Dim fName As String
posn = 0
'find the position of the last "\" character in filename
For i = 1 To Len(flname)
If (Mid(flname, i, 1) = "\") Then posn = i
Next i
'get filename without path
fName = Right(flname, Len(flname) - posn)
'get filename without extension
posn = InStr(fName, ".")
If posn <> 0 Then
fName = Left(fName, posn - 1)
End If
GetFileName = fName
End Function
输入时
C:\Documents and Settings\Arshad\My Documents\ravi.txt
这个函数返回
ravi
该函数被称为:
Dim FileName As String
FileName = GetFileName("C:\Documents and Settings\Arshad\My Documents\ravi.txt")
