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
| Private Sub TextBox1_Change()
Tick Format(TextBox1, "yyyy-mm-dd hh:mm:ss")
End Sub
Private Sub Myhwile()
While True
Dim tt As Date
DoEvents
Dim ee As String, i As Integer
ee = WebBrowser1.Document.Body.InnerHtml
Dim a() As String
a() = Split(ee, "DIV")
Dim r As String
r = Replace(Split(Split(Split(a(2), ">")(1), "<")(0), ",")(1), ".", "") '.(.Replace(".", "")a(2).Split(">")(1).Split("<")(0).Split(",")(1).(
a = Split(r)
For i = 0 To 12
If a(2) = Array("Janvier", "Février", "Mars", "Avr", "Mai", "Juin", "Juil", "Août", "Sept", "Oct", "Nov", "Déc")(i) Then
TextBox1 = DateSerial(CInt(a(3)), i + 1, a(1)) & " " & Split(Split(Split(ee, "DIV")(4), "<SPAN class=hour>")(1), "<")(0) & ":" & Split(Split(Split(ee, "DIV")(4), "<SPAN class=minute>")(1), "<")(0) & ":" & Split(Split(Split(ee, "DIV")(4), "<SPAN class=second>")(1), "<")(0)
Exit For
End If
Next
Wend
End Sub
Private Sub UserForm_Initialize()
With Me.WebBrowser1
.Navigate ("https://www.zeitverschiebung.net/clock-widget-iframe-v2?language=fr&size=medium&timezone=Europe%2FParis")
Do: DoEvents: Loop While .ReadyState() <> 4 Or .Busy
End With
Me.Hide
Myhwile
End Sub |
Partager