Excel
Sauter à la navigation
Sauter à la recherche
Sommaire
VBA/Excel…
VBA de suppression de PW Excel :
Sub enleve_protection()
Dim a, b, c, d, e, f, g, h, i, j, k, l As Integer
On Error Resume Next
For a = 65 To 66
For b = 65 To 66
For c = 65 To 66
For d = 65 To 66
For e = 65 To 66
For f = 65 To 66
For g = 65 To 66
For h = 65 To 66
For i = 65 To 66
For j = 65 To 66
For k = 65 To 66
For l = 32 To 126
ActiveSheet.Unprotect Chr(a) & Chr(b) & Chr(c) & Chr(d) & Chr(e) & Chr(f) & Chr(g) & Chr(h) & Chr(i) & Chr(j) & Chr(k) & Chr(l)
If ActiveSheet.ProtectContents = False Then
MsgBox "La protection a été enlevée - Un mot de passe satisfaisant est :" & Chr(a) & Chr(b) & Chr(c) & Chr(d) & Chr(e) & Chr(f) & Chr(g) & Chr(h) & Chr(i) & Chr(j) & Chr(k) & Chr(l)
Exit Sub
End If
Next
Next
Next
Next
Next
Next
Next
Next
Next
Next
Next
Next
End Sub
TimeStamp => Ecxel
Convertir en jj/mm/aaaa hh:mm:ss
time stamp/86400+25569
Extraction dernier mot
=SI(NBCAR(A2)=0;"";SI(NBCAR(A2)=NBCAR(SUBSTITUE(A2;"/";""));A2;DROITE(A2;NBCAR(A2)-CHERCHE("µ";SUBSTITUE(A2;"/";"µ";NBCAR(A2)-NBCAR(SUBSTITUE(A2;"/";"")));1))))