KEHREN Seb
XLDnaute Nouveau
Depuis la fin d'internet explorer qui est remplacé par EDGE : la commande CreateObject("InternetExplorer.Application") ne fonctonne plus
Avez vous une solution?
Option Explicit
Dim web As Object
Set web = CreateObject("InternetExplorer.Application")
web.Visible = True
Do While web.busy And web.readystate <> 4
DoEvents
Loop
pause (10)
Dim redirection As String
redirection = web.locationUrl
redirection = Right(redirection, Len(redirection) - InStr(redirection, "@"))
Dim redirectionSplitee As Variant
redirectionSplitee = Split(redirection, ",")
redirection = Replace(redirectionSplitee(0) & "/" & redirectionSplitee(1), ".", ",")
web.Quit
coordonneesGPS = redirection
End Function
Avez vous une solution?
Option Explicit
Dim web As Object
Set web = CreateObject("InternetExplorer.Application")
web.Visible = True
Do While web.busy And web.readystate <> 4
DoEvents
Loop
pause (10)
Dim redirection As String
redirection = web.locationUrl
redirection = Right(redirection, Len(redirection) - InStr(redirection, "@"))
Dim redirectionSplitee As Variant
redirectionSplitee = Split(redirection, ",")
redirection = Replace(redirectionSplitee(0) & "/" & redirectionSplitee(1), ".", ",")
web.Quit
coordonneesGPS = redirection
End Function