1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| Option Explicit
Sub LogArretPC()
Dim derL As Long
Dim Ws As Worksheet
Set Ws = Sheets("data démarrage-arrêt")
Application.ScreenUpdating = False
derL = Ws.Range("A1").CurrentRegion.Rows.Count + 1
Ws.Rows(derL).Insert
With Ws.Range(Ws.Cells(derL, 1), Ws.Cells(derL, 1).Offset(0, 7)).Interior
.Pattern = xlNone
.TintAndShade = 0
.PatternTintAndShade = 0
End With
With Ws.Cells(derL, 1)
.Value = "Arrêt"
.Offset(0, 1).Value = Format(Date, "yyyy-mm-dd")
.Offset(0, 2).Value = Format(Time, "hh:mm:ss")
.Offset(0, 3).Value = Environ("Username")
.Offset(0, 4).Value = Environ("ComputerName")
.Offset(0, 5).Value = Environ("Userdomain")
.Offset(0, 6).FormulaR1C1 = "=RC[-4]-R[-1]C[-4]"
End With
'ActiveWorkbook.Save
'ActiveWorkbook.Close
Application.ScreenUpdating = True
End Sub |
Partager