Excel

De Wiki-noulot
Sauter à la navigation Sauter à la recherche

VBA/Excel…[modifier]

VBA de suppression de PW Excel :[modifier]

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[modifier]

Convertir en jj/mm/aaaa hh:mm:ss

  time stamp/86400+25569

Extraction dernier mot[modifier]

=SI(NBCAR(A2)=0;"";SI(NBCAR(A2)=NBCAR(SUBSTITUE(A2;"/";""));A2;DROITE(A2;NBCAR(A2)-CHERCHE("µ";SUBSTITUE(A2;"/";"µ";NBCAR(A2)-NBCAR(SUBSTITUE(A2;"/";"")));1))))