KLAVYEDE TUŞ BASMA SORUNU

Katılım
30 Kasım 2018
Mesajlar
91
Excel Vers. ve Dili
2016
Arkadaşla aşağıdaki formülde klavyeden Alt+sol tuşuna bastırmak istiyorum fakat olmuyor. nedeni ne olabilir.



Sub DENEME_Arama()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
Application.Wait Now + TimeValue("00:00:02")
IE.Navigate "https:/deneme/Isgucu/IsverenListele.aspx"
Application.Wait Now + TimeValue("00:00:02")
IE.Width = 1500
IE.Height = 1000
IE.Visible = True
While IE.Busy
DoEvents
Wend
son = Cells(Rows.Count, "A").End(3).Row
For i = 2 To son
If Cells(i, "A") = "" Then
Cells(i, "C") = "Ne verdin ki ne alasın!!!"
Else
IE.document.getElementById("ctl04_ctlI").Value = Cells(i, "A")
IE.Visible = True
While IE.Busy
DoEvents
Wend
Set TrackID = IE.document.getElementById("ctl04_ctlPageCommand_CommandItem_Search")
IE.document.getElementById("ctl04_ctlPageCommand_CommandItem_Search").Click
IE.Visible = True
While IE.Busy
DoEvents
Wend
Set TrackID = IE.document.getElementById("ctl04_ctlGrid_ctl02_LinkButton1")
IE.document.getElementById("ctl04_ctlGrid_ctl02_LinkButton1").Click
IE.Visible = True
While IE.Busy
DoEvents
Wend
Set TrackID = IE.document.getElementById("ctl04_ctlPageCommand_CommandItem_SeeDetail")
IE.document.getElementById("ctl04_ctlPageCommand_CommandItem_SeeDetail").Click
IE.Visible = True
While IE.Busy
DoEvents
Wend
Application.SendKeys "alt + sol"
IE.Visible = True
While IE.Busy
DoEvents
Wend

End If
Next
IE.Quit
End Sub
 

netzone

Altın Üye
Katılım
10 Mayıs 2006
Mesajlar
791
Excel Vers. ve Dili
🅾🅵🅵🅸🅲🅴
⎝365 64 Bit 𝙏𝙍⎠
🆆🅸🅽🅳🅾🆆🆂
⎝11 64 Bit 𝙏𝙍⎠
Altın Üyelik Bitiş Tarihi
12-09-2027
Üst