i want to get data from google suggestion
how to get the data taken can be neatly arranged and repeated based on the data taken
example: first keyword: "study"
Successfully retrieved keywords:
Study Island
Study
Study Stream
Study Table
second keyword: "Study Island" etc
my code
I hope the code can be converted with XmlHttpRequest to make it faster
how to get the data taken can be neatly arranged and repeated based on the data taken
example: first keyword: "study"
Successfully retrieved keywords:
Study Island
Study
Study Stream
Study Table
second keyword: "Study Island" etc
my code
VBA Code:
Sub tes()
Dim sData As Worksheet: Set sData = Sheets("Sheet1")
Set ch = New Selenium.ChromeDriver
On Error Resume Next
With ch
.AddArgument "--start-maximized"
.Start
.SwitchToNextWindow
.Get "https://www.google.com/"
Application.Wait (Now + TimeValue("0:00:03"))
End With
ch.FindElementByName("q").SendKeys "Study"
Application.Wait (Now + TimeValue("0:00:05"))
Sheets("Sheet1").Range("C1") = ch.FindElementByClass("aajZCb").Text
End Sub
I hope the code can be converted with XmlHttpRequest to make it faster