[COLOR=NAVY]Private Sub[/COLOR] WebBrowser1_DocumentComplete([COLOR=NAVY]ByVal[/COLOR] pDisp [COLOR=NAVY]As Object[/COLOR], URL [COLOR=NAVY]As Variant[/COLOR])
[COLOR=NAVY]Dim[/COLOR] TabTemp [COLOR=NAVY]As Variant
Dim[/COLOR] L2 [COLOR=NAVY]As Long[/COLOR], Lign [COLOR=NAVY]As Long
Static[/COLOR] L [COLOR=NAVY]As Long
If[/COLOR] URL = UrlDepart [COLOR=NAVY]Then
If[/COLOR] Cells(1, 1).Interior.ColorIndex = xlNone [COLOR=NAVY]Then[/COLOR] L = 0
L = L + 1
[COLOR=NAVY]With[/COLOR] WebBrowser1.Document
.all("[CP][CP]").Value = Cells(L, 1).Text
.all("B2").Click
Cells(L, 1).Interior.ColorIndex = 6
[COLOR=NAVY] End [/COLOR]With
[COLOR=NAVY] El[/COLOR]seIf URL = "http://www.france-darts.com/gestion/htm/DPD.A[COLOR=NAVY]SP" [/COLOR]Then
Application.ScreenUpdatin[COLOR=NAVY]g = F[/COLOR]alse
TabTemp = Split(WebBrowser1.Document.Body.InnerText(), vbCrLf)
With Sheets("Opérateur")
Lign = .Cells(Application.Rows.Count,[COLOR=NAVY] 1)[/COLOR].End(xlUp).Row + 1
For L2 [COLOR=NAVY]= [/COLOR]8[COLOR=NAVY] To UB[/COLOR]ound(TabTe[COLOR=NAVY]mp) [/COLOR]Step 8
If Application.CountIf(.Columns(1), TabTemp(L2)) [COLOR=NAVY]= 0 [/COLOR]Then
.Cells(Lign, 1).Value = TabTemp(L2)
Lign = Lign + 1
[COLOR=NAVY] En[/COLOR]d If
Next L2
[COLOR=NAVY] End [/COLOR]With
Application.ScreenUpdatin[COLOR=NAVY]g = [/COLOR]True
If Cells(L + 1, 1) <>[COLOR=NAVY] "" [/COLOR]Then btnGo_Cl[COLOR=NAVY]ick [/COLOR]Else MsgBox ("Traitement terminé !")
[COLOR=NAVY] En[/COLOR]d[COLOR=NAVY] If
End[/COLOR]