| 12
 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
 64
 65
 66
 67
 68
 
 | Option Explicit
 
Sub extractionDonneesPageHtml()
'necessite d'activer la reference Microsoft Internet Controls
Dim IE As InternetExplorer
Dim nFile As Integer
Dim infosLigne As String
Dim i As Byte
Dim Lig As Boolean
 
Set IE = CreateObject("InternetExplorer.Application")
 
With IE
    .Visible = False
    .Silent = True
    .Navigate "http://www.allocine.fr/series/episodes_gen_csaison=118&cserie=55.html"
    Do Until .ReadyState = READYSTATE_COMPLETE
    DoEvents
    Loop 'attend la fin du chargement
 
    nFile = FreeFile
    Open "C:\test.txt" For Output Shared As #nFile
    Print #nFile, .Document.DocumentElement.InnerText
    Close #nFile
    .Quit
End With
 
Set IE = Nothing
 
Lig = False
 
Open "C:\test.txt" For Input As #1
Do While Not EOF(1)
Line Input #1, infosLigne
    If Left(infosLigne, 7) = "Episode" Then
    i = i + 1
    Cells(i, 1) = Mid(infosLigne, InStr(1, infosLigne, "-") + 2, _
    Len(infosLigne) - InStr(1, infosLigne, "-"))
    End If
 
    If Lig = True Then
    Cells(i, 6) = infosLigne
    Lig = False
    End If
 
    If Left(infosLigne, 14) = "Titre original" Then
    Cells(i, 2) = Mid(infosLigne, InStr(1, infosLigne, ":") + 2, _
    Len(infosLigne) - InStr(1, infosLigne, ":"))
    Lig = True
    End If
 
    If Left(infosLigne, 11) = "Réalisé par" Then _
    Cells(i, 3) = Mid(infosLigne, InStr(1, infosLigne, ":") + 2, _
    Len(infosLigne) - InStr(1, infosLigne, "-"))
 
    If Left(infosLigne, 9) = "Ecrit par" Then _
    Cells(i, 4) = Mid(infosLigne, InStr(1, infosLigne, ":") + 2, _
    Len(infosLigne) - InStr(1, infosLigne, ":"))
 
    If Left(infosLigne, 19) = "Acteurs secondaires" Then _
    Cells(i, 5) = Mid(infosLigne, InStr(1, infosLigne, ":") + 2, _
    Len(infosLigne) - InStr(1, infosLigne, ":"))
 
Loop
Close #1
 
Kill "C:\test.txt"
End Sub |