取路径:
Public Function GetFileFolder(ByVal sFilename As String) As String
Dim iEnd
iEnd = InStrRev(sFilename, "/")
If iEnd = 0 Then
iEnd = InStrRev(sFilename, "\")
End If
If iEnd > 0 Then
GetFileFolder = Mid(sFilename, 1, iEnd)
Else
GetFileFolder = ""
End If
End Function取文件名:
Public Function GetFileName(ByVal sFilename As String) As String
Dim iStart
iStart = InStrRev(sFilename, "/") + 1
If iStart = 0 Then
iStart = InStrRev(sFilename, "\") + 1
End If
If iStart = 0 Then
iStart = 1
End If
GetFileName = Mid(sFilename, iStart)
End Function
Dim strpath As String
myarr = Split("c:\game\rpl\pal.exe", "\", -1, vbTextCompare)
strpath = myarr(UBound(myarr))
MsgBox strpath
Dim r As String
r = a.GetFileName("c:\game\rpl\pal.exe")
Set a = Nothing
对于\\Net\ABC\Test.txt这种格式也是一样的
因为取得的字符串是最后面的Test.txt
对于\\Net\ABC\Test.txt这种格式也是一样的
因为取得的字符串是最后面的Test.txt
有?!
当然没用了!
要改成这样!
取路径:
Public Function GetFileFolder(ByVal sFilename As String) As String
Dim iEnd
iEnd = InStrRev(sFilename, "/")
If iEnd = 0 Then
iEnd = InStrRev(sFilename, "\")
End If
If iEnd > 0 Then
GetFileFolder = Mid(sFilename, 1, iEnd)
Else
GetFileFolder = ""
End If
End Function取文件名:
Public Function GetFileName(ByVal sFilename As String) As String
Dim iStart
iStart = InStrRev(sFilename, "/")
If iStart = 0 Then
iStart = InStrRev(sFilename, "\")
End If
iStart=iStart+1
GetFileName = Mid(sFilename, iStart)
End Function