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 53 54 55 56 57 58 59 60 61 62 63
| Sub Lire_Tableau_SRD_Myta()
Dim IE As New InternetExplorer
Dim IEDoc As HTMLDocument
Dim HtmlTag As IHTMLElementCollection
Dim Titre(2) As String, Valeur(6) As String 'Titre(2)
Dim Cel As Range, I As Integer
ligne = 1
Sheets("Tableau SRD").Select
ActiveSheet.Unprotect
IE.Navigate [A2]
IE.Visible = True
Do Until IE.readyState = READYSTATE_COMPLETE
DoEvents
Loop
Set IEDoc = IE.document
Set HtmlTag = IEDoc.getElementsByTagName("td")
Titre(0) = "ACCOR": Valeur(0) = "N/A"
For I = 0 To HtmlTag.Length - 1
If HtmlTag.Item(I).innerText = Titre(0) Then
For x = I To HtmlTag.Length - 1 Step 8
ligne = ligne + 1
If Left(HtmlTag.Item(x).innerHTML, 7) = "<script" Then
I = HtmlTag.Length - 1
Exit For
End If
Cells(ligne, 2) = HtmlTag.Item(x).innerText
Cells(ligne, 3) = HtmlTag.Item(x + 1).innerText
Cells(ligne, 4) = HtmlTag.Item(x + 2).innerText
Cells(ligne, 5) = HtmlTag.Item(x + 3).innerText
Cells(ligne, 6) = HtmlTag.Item(x + 4).innerText
tabl = Split(HtmlTag.Item(x + 5).innerHTML, "alt=""")
On Error Resume Next
Cells(ligne, 7) = Split(tabl(1), """ src")(0)
If Err.Number <> 0 Then
Cells(ligne, 7) = HtmlTag.Item(x + 5).innerText
Err.Clear
End If
On Error GoTo 0
Cells(ligne, 8) = HtmlTag.Item(x + 6).innerText
Cells(ligne, 9) = HtmlTag.Item(x + 7).innerText
Next x
End If
Next I
IE.Visible = False
IE.Quit
Set HtmlTag = Nothing
Set IEDoc = Nothing
Set IE = Nothing
Range("B1").Select
ActiveSheet.Protect
ActiveWorkbook.Save
End Sub |
Partager