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
| ' AJOUTER : '
' Référence à Microsoft Internet Controls (Internet Explorer) : shdocvw.dll si <= IE6, sinon ieframe.dll
' Référence à Microsoft HTML Object Librairy (DOM) : msHTML.tlb
Private WithEvents clsIE As InternetExplorer
Private htmlDoc_ As HTMLDocument
Private url_ As String
Private Const defEuroId As String = "aj_last_1xEURUS"
Private Const defUrl As String = "http://www.boursorama.com/cours.phtml?symbole=1xEURUS"
Public Event EuroActualize(value As String)
Private Sub Class_Initialize(): Set clsIE = New InternetExplorer: End Sub
Public Sub Refresh(Optional Url As String = defUrl): url_ = Url: clsIE.Navigate url_: End Sub
Private Sub clsIE_DocumentComplete(ByVal pDisp As Object, Url As Variant)
Dim dElem As Object, ret As String
' Le document demandé est chargé dans son intégralité '
If Url = url_ Then
' On récupère le contenu '
Set htmlDoc_ = clsIE.document
' pour chaque balise <span> '
For Each dElem In htmlDoc_.getElementsByTagName("span")
' La valeur cherchée est trouvée '
If dElem.getAttribute("id") = defEuroId Then
' alors on génère l'évènement '
RaiseEvent EuroActualize(dElem.innerHTML)
Exit Sub
End If
Next
End If
End Sub |
Partager