1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
Public Sub SaveCopy()
Dim strDate As String
Dim Count As integer
Dim PosSep As Intger
Count = Len(ActiveWorkbook.Name)
PosSep = InStrRev(ActiveWorkbook.Name, ".")
'--- Extension xls ou xlsm (3 ou 4 car.)
If PosSep = 0 Then
NameA = ActiveWorkbook.Name
Else
NameA = Left(ActiveWorkbook.Name, PosSep - 1)
End If
'--- Ajout séparateur si besoin
If Right(ActiveWorkbook.Path, 1) <> "\" Then
NameA = ActiveWorkbook.Path & "\" & NameA
Else
NameA = ActiveWorkbook.Path & NameA
End If
'---
strDate = Format(Date, "dd-mm-yy") & "_" & Format(Time, "hh-mm-ss")
ThisWorkbook.SaveCopyAs Filename:=NameA & "_" & strDate & Right(ActiveWorkbook.Name, Count - PosSep + 1)
End Sub |
Partager