<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="fr">
	<id>http://wiki.les-noulot.fr/index.php?action=history&amp;feed=atom&amp;title=Excel</id>
	<title>Excel - Historique des versions</title>
	<link rel="self" type="application/atom+xml" href="http://wiki.les-noulot.fr/index.php?action=history&amp;feed=atom&amp;title=Excel"/>
	<link rel="alternate" type="text/html" href="http://wiki.les-noulot.fr/index.php?title=Excel&amp;action=history"/>
	<updated>2026-11-17T08:42:22Z</updated>
	<subtitle>Historique des versions pour cette page sur le wiki</subtitle>
	<generator>MediaWiki 1.33.0</generator>
	<entry>
		<id>http://wiki.les-noulot.fr/index.php?title=Excel&amp;diff=347&amp;oldid=prev</id>
		<title>Sebastien : Page créée avec « =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... »</title>
		<link rel="alternate" type="text/html" href="http://wiki.les-noulot.fr/index.php?title=Excel&amp;diff=347&amp;oldid=prev"/>
		<updated>2017-01-04T08:49:45Z</updated>

		<summary type="html">&lt;p&gt;Page créée avec « =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... »&lt;/p&gt;
&lt;p&gt;&lt;b&gt;Nouvelle page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;=VBA/Excel…=&lt;br /&gt;
&lt;br /&gt;
==VBA de suppression de PW Excel :==&lt;br /&gt;
 Sub enleve_protection()&lt;br /&gt;
    Dim a, b, c, d, e, f, g, h, i, j, k, l As Integer&lt;br /&gt;
       On Error Resume Next&lt;br /&gt;
       For a = 65 To 66&lt;br /&gt;
       For b = 65 To 66&lt;br /&gt;
       For c = 65 To 66&lt;br /&gt;
       For d = 65 To 66&lt;br /&gt;
       For e = 65 To 66&lt;br /&gt;
       For f = 65 To 66&lt;br /&gt;
       For g = 65 To 66&lt;br /&gt;
       For h = 65 To 66&lt;br /&gt;
       For i = 65 To 66&lt;br /&gt;
       For j = 65 To 66&lt;br /&gt;
       For k = 65 To 66&lt;br /&gt;
       For l = 32 To 126&lt;br /&gt;
              ActiveSheet.Unprotect Chr(a) &amp;amp; Chr(b) &amp;amp; Chr(c) &amp;amp; Chr(d) &amp;amp; Chr(e) &amp;amp; Chr(f) &amp;amp; Chr(g) &amp;amp; Chr(h) &amp;amp; Chr(i) &amp;amp; Chr(j) &amp;amp; Chr(k) &amp;amp; Chr(l)&lt;br /&gt;
              If ActiveSheet.ProtectContents = False Then&lt;br /&gt;
              MsgBox &amp;quot;La protection a été enlevée - Un mot de passe satisfaisant est :&amp;quot; &amp;amp; Chr(a) &amp;amp; Chr(b) &amp;amp; Chr(c) &amp;amp; Chr(d) &amp;amp; Chr(e) &amp;amp; Chr(f) &amp;amp; Chr(g) &amp;amp; Chr(h) &amp;amp; Chr(i) &amp;amp; Chr(j) &amp;amp; Chr(k) &amp;amp; Chr(l)&lt;br /&gt;
              Exit Sub&lt;br /&gt;
              End If&lt;br /&gt;
       Next&lt;br /&gt;
       Next&lt;br /&gt;
       Next&lt;br /&gt;
       Next&lt;br /&gt;
       Next&lt;br /&gt;
       Next&lt;br /&gt;
       Next&lt;br /&gt;
       Next&lt;br /&gt;
       Next&lt;br /&gt;
       Next&lt;br /&gt;
       Next&lt;br /&gt;
       Next&lt;br /&gt;
  End Sub&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
==TimeStamp =&amp;gt; Ecxel==&lt;br /&gt;
&lt;br /&gt;
Convertir en jj/mm/aaaa hh:mm:ss&lt;br /&gt;
   time stamp/86400+25569&lt;br /&gt;
&lt;br /&gt;
==Extraction dernier mot==&lt;br /&gt;
&lt;br /&gt;
 =SI(NBCAR(A2)=0;&amp;quot;&amp;quot;;SI(NBCAR(A2)=NBCAR(SUBSTITUE(A2;&amp;quot;/&amp;quot;;&amp;quot;&amp;quot;));A2;DROITE(A2;NBCAR(A2)-CHERCHE(&amp;quot;µ&amp;quot;;SUBSTITUE(A2;&amp;quot;/&amp;quot;;&amp;quot;µ&amp;quot;;NBCAR(A2)-NBCAR(SUBSTITUE(A2;&amp;quot;/&amp;quot;;&amp;quot;&amp;quot;)));1))))&lt;/div&gt;</summary>
		<author><name>Sebastien</name></author>
		
	</entry>
</feed>