Dans ce cas, on va faire un test.
Ouvre geny.com et identifie-toi normalement.
Ensuite clique sur le bouton de ce fichier ... attention, la procédure dure 10 secondes, il y a des tempos partout car le but est de laisser excel dialoguer avec firefox.
Quel est le résultat obtenu ?
Si pas concluant, recommence une seconde fois et donne moi la réponse.
Private Declare Function ShellExecute _
Lib "shell32.dll" _
Alias "ShellExecuteA" ( _
ByVal hwnd As Long, _
ByVal lpOperation As String, _
ByVal lpFile As String, _
ByVal lpParameters As String, _
ByVal lpDirectory As String, _
ByVal nShowCmd As Long) _
As Long
Sub telecharger()
Dim nav As Long, MyData As DataObject
Set MyData = New DataObject
Sheets("source").Select
Cells.Clear
Range("A1").Select
nav = ShellExecute(0, "open", "https://www.qwant.com/", 0, 0, 1)
Application.Wait (Now + TimeValue("00:00:02"))
SendKeys "%d"
Application.Wait (Now + TimeValue("00:00:01"))
SendKeys "view-source:" & [_URL]
SendKeys "{ENTER}"
Application.Wait (Now + TimeValue("00:00:04"))
SendKeys "^a"
Application.Wait (Now + TimeValue("00:00:01"))
SendKeys "^c"
Application.Wait (Now + TimeValue("00:00:01"))
MyData.GetFromClipboard
txt = [_avant] & Split(Split(MyData.GetText(1), [_avant])(1), [_apres])(0) & [_apres]
SendKeys "%{F4}"
MyData.SetText Text:=Empty
MyData.PutInClipboard
MyData.SetText txt
MyData.PutInClipboard
Application.Wait (Now + TimeValue("00:00:01"))
ActiveSheet.Paste
End Sub