1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
|
Private Function GetFileName(ByVal FileName As String) As String
Dim strDate As String
Dim strTime As String
Dim I As Integer
Dim J As Integer
Dim strFileName As String
strFileName = Left$(FileName, InStrRev(FileName, ".") - 1)
I = InStr(1, strFileName, "_")
strDate = Mid$(strFileName, I + 1, 4)
Select Case Len(strDate)
Case 3: strDate = Left$(strDate, 1) & "/" & Mid$(strDate, 2, 2)
Case 4: strDate = Left$(strDate, 2) & "/" & Mid$(strDate, 3, 2)
End Select
J = InStr(I + 1, strFileName, "_")
strTime = Trim$(Mid$(strFileName, J + 1, 4))
Select Case Len(strTime)
Case 3: strTime = Left$(strTime, 1) & "h" & Mid$(strTime, 2, 2)
Case 4: strTime = Left$(strTime, 2) & "h" & Mid$(strTime, 3, 2)
End Select
GetFileName = Left$(strFileName, I - 1) & " le " & strDate & " à " & strTime
End Function |
Partager