'给你一个函数 根据文件地址获取文件名
Function fGetLast(ByVal originalString As String) As String
Dim tmps() As String
Dim delimeter As String
delimeter = "\" '分隔符
tmps = Split(originalString, delimeter)
fGetLast = tmps(UBound(tmps))
End Function
Private Sub Command1_Click()
Dim a As String
a = "C:\伟大无比的PLUMLEE啊.txt" '例如a 是 这个路径
Form1.Caption = fGetLast(a) & " - 记事本" '我调用A //// fGetLast(文件的地址)
End Sub
VB 提取文件名 (2011-04-26 14:16:31)
伟大的PLUMLEE
带扩展名的文件名
Private Sub Form_Load()
Dim nopath As String
nopath = TrimPath("C:\TXTFILES\JUSTFILE.TXT")
MsgBox nopath
End Sub
Public Function TrimPath(sPath As String) As String
Dim i As Integer, j As Integer
i = InStrRev(sPath, "\") + 1
TrimPath = Mid(sPath, i)
End Function
----------------------------------------------------------------------------------------------------------
'不带扩展名的文件名
Private Sub Form_Load()
Dim nopath As String
nopath$ = TrimPath("C:\TXTFILES\JUSTFILE.TXT")
MsgBox nopath
End Sub
Public Function TrimPath(sPath As String) As String
Dim i As Integer, j As Integer
i = InStrRev(sPath, "\") + 1
j = InStrRev(sPath, ".") - 1
TrimPath = Mid(sPath, i, j - i)
End Function
----------------------------------------------------------------------------------------------------------
'只返回扩展名
Private Sub Form_Load()
Dim nopath As String
nopath = TrimPath("C:\TXTFILES\JUSTFILE.TXT")
MsgBox nopath
End Sub
Public Function TrimPath(sPath As String) As String
Dim i As Integer
i = InStrRev(sPath, ".")+1
TrimPath = Mid(sPath, i)
End Function
----------------------------------------------------------------------------------------------------------
'托放操作得到文件扩展名
Private Sub Form_Load()
Me.OLEDropMode = 1
End Sub
Private Sub Form_OLEDragDrop(Data As DataObject, Effect As Long, Button As Integer, Shift As Integer, X As Single, Y As Single)
Print TrimPath(Data.Files(1))
End Sub
Public Function TrimPath(sPath As String) As String
Dim i As Integer
i = InStrRev(sPath, ".") + 1
If i = 1 Then
TrimPath = "这可能是文件夹或没有扩展名的文件"
Exit Function
End If
TrimPath = Mid(sPath, i)
End Function
Private Sub Form_Load()
Dim nopath As String
nopath = TrimPath("C:\TXTFILES\JUSTFILE.TXT")
MsgBox nopath
End Sub
Public Function TrimPath(sPath As String) As String
Dim i As Integer, j As Integer
i = InStrRev(sPath, "\") + 1
TrimPath = Mid(sPath, i)
End Function
----------------------------------------------------------------------------------------------------------
'不带扩展名的文件名
Private Sub Form_Load()
Dim nopath As String
nopath$ = TrimPath("C:\TXTFILES\JUSTFILE.TXT")
MsgBox nopath
End Sub
Public Function TrimPath(sPath As String) As String
Dim i As Integer, j As Integer
i = InStrRev(sPath, "\") + 1
j = InStrRev(sPath, ".") - 1
TrimPath = Mid(sPath, i, j - i)
End Function
----------------------------------------------------------------------------------------------------------
'只返回扩展名
Private Sub Form_Load()
Dim nopath As String
nopath = TrimPath("C:\TXTFILES\JUSTFILE.TXT")
MsgBox nopath
End Sub
Public Function TrimPath(sPath As String) As String
Dim i As Integer
i = InStrRev(sPath, ".")+1
TrimPath = Mid(sPath, i)
End Function
----------------------------------------------------------------------------------------------------------
'托放操作得到文件扩展名
Private Sub Form_Load()
Me.OLEDropMode = 1
End Sub
Private Sub Form_OLEDragDrop(Data As DataObject, Effect As Long, Button As Integer, Shift As Integer, X As Single, Y As Single)
Print TrimPath(Data.Files(1))
End Sub
Public Function TrimPath(sPath As String) As String
Dim i As Integer
i = InStrRev(sPath, ".") + 1
If i = 1 Then
TrimPath = "这可能是文件夹或没有扩展名的文件"
Exit Function
End If
TrimPath = Mid(sPath, i)
End Function