Guido
XLDnaute Accro
Bonjour le Forum
Voici mon probleme
apres avoir lancé ma macros...un debocage s'affiche,voir le texte..
Sub Get_Course(Lien As String)
Dim Cel As Range
With F01
With .QueryTables.Add( _
Connection:="URL;" & Lien, _
Destination:=.Range("B8"))
.BackgroundQuery = True
.RefreshStyle = xlOverwriteCells
.WebSelectionType = xlSpecifiedTables
.WebTables = "1"
.TablesOnlyFromHTML = True
.WebDisableDateRecognition = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With
If .Range("C8") = "E-mail" Then
With .QueryTables.Add( _
Connection:="URL;" & Lien, _
Destination:=.Range("B8"))
.BackgroundQuery = True
.RefreshStyle = xlOverwriteCells
.WebSelectionType = xlSpecifiedTables
.WebTables = "2"
.TablesOnlyFromHTML = True
.WebDisableDateRecognition = True
.Refresh BackgroundQuery:=False <<<<<<Voici la phrase en jaune.......
.SaveData = True
End With
End If
Set Cel = .Range("B9:L9").Find("Musique", LookIn:=xlValues)
If Not Cel Is Nothing Then
Cel.Offset(, 2) = "Cotes Réf.": Cel.Offset(, 3) = "Der. Cotes"
End If
End With
End Sub
Merci d'avance
Guido
Voici mon probleme
apres avoir lancé ma macros...un debocage s'affiche,voir le texte..
Sub Get_Course(Lien As String)
Dim Cel As Range
With F01
With .QueryTables.Add( _
Connection:="URL;" & Lien, _
Destination:=.Range("B8"))
.BackgroundQuery = True
.RefreshStyle = xlOverwriteCells
.WebSelectionType = xlSpecifiedTables
.WebTables = "1"
.TablesOnlyFromHTML = True
.WebDisableDateRecognition = True
.Refresh BackgroundQuery:=False
.SaveData = True
End With
If .Range("C8") = "E-mail" Then
With .QueryTables.Add( _
Connection:="URL;" & Lien, _
Destination:=.Range("B8"))
.BackgroundQuery = True
.RefreshStyle = xlOverwriteCells
.WebSelectionType = xlSpecifiedTables
.WebTables = "2"
.TablesOnlyFromHTML = True
.WebDisableDateRecognition = True
.Refresh BackgroundQuery:=False <<<<<<Voici la phrase en jaune.......
.SaveData = True
End With
End If
Set Cel = .Range("B9:L9").Find("Musique", LookIn:=xlValues)
If Not Cel Is Nothing Then
Cel.Offset(, 2) = "Cotes Réf.": Cel.Offset(, 3) = "Der. Cotes"
End If
End With
End Sub
Merci d'avance
Guido