1,453
社区成员




Dim s1 As String
Dim k As Long
s1 = "111.html"
k = InStrRev(s1, ".")
If k > 0 Then
s1 = Left(s1, k - 1) + ".Djc"
Else
s1 = s1 + ".Djc"
End If
Debug.Print "s1=[" + s1 + "]"
Dim s1 As String
Dim k As Long
s1 = "111"
k = InStrRev(s1, ".")
If k > 0 Then
s1 = Left(s1, k - 1) + ".Djc"
Else
s1 = s1 + ".Djc"
End If
Debug.Print "s1=[" + s1 + "]"