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 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52
| Sub Lire_Cours_Potentiels()
Dim IE As New InternetExplorer
Dim IEDoc As HTMLDocument
Dim HtmlTag As IHTMLElementCollection
Dim Valeur1 As String, Valeur2 As String
Dim Cel As Range, I As Integer
Sheets("Cours et Potentiels").Select
ActiveSheet.Unprotect
For Each Cel In Range("A2:A" & Cells(Rows.Count, 1).End(xlUp).Row)
IE.Navigate Cel
IE.Visible = True
Do Until IE.readyState = READYSTATE_COMPLETE
DoEvents
Loop
Set IEDoc = IE.document
Set HtmlTag = IEDoc.getElementsByTagName("td")
Valeur1 = "N/A": Valeur2 = "N/A"
For I = 0 To HtmlTag.Length + 1
If HtmlTag.Item(I).innerText = "Cours" Then
Valeur1 = HtmlTag.Item(I + 1).innerText 'Valeur1 = HtmlTag.Item(I + 1).innerText
If HtmlTag.Item(I).innerText = "Cours" Then
Valeur2 = HtmlTag.Item(I + 23).innerText 'Valeur2 = HtmlTag.Item(I - 1).innerText '
End If
Exit For
End If
Next I
Cel.Offset(, 3) = Valeur1
Cel.Offset(, 2) = Valeur2
Next Cel
IE.Visible = False
Set HtmlTag = Nothing
Set IEDoc = Nothing
Set IE = Nothing
IE.Visible = False
Range("B1").Select
ActiveSheet.Protect
ActiveWorkbook.Save
End Sub |
Partager