Dim driver As New ChromeDriver
Public Sub Novoscrap()
Dim ck As New By
Dim w As Worksheet
Dim r As Range
Dim m As Worksheet
Dim linkSemEscanteio As Variant
Dim celulaApagar As Integer
Application.EnableCancelKey = xlDisabled
Application.OnTime Now + TimeValue("00:05:00"), "validaHora"
If PlanEstats.Range("A2") <> "" Then
PlanEstats.Select
PlanEstats.Rows("2:110").Select
Selection.Delete Shift:=xlUp
End If
Set m = Sheets("Links")
m.Select
m.Range("A2").Select
If ActiveCell.Value = "" Then
MsgBox "Sem link valida na celula A2 da Aba Jogos de Hoje."
Exit Sub
End If
Set driver = New ChromeDriver
driver.AddArgument ("--headless")
Do While ActiveCell.Value <> ""
driver.Get (ActiveCell.Value)
On Error Resume Next
If driver.IsElementPresent(ck.XPath("/html/body/div/div/div/div[3]/div[2]/div[2]/div[2]/div[2]/div[1]/span/span[1]"), 0) And driver.IsElementPresent(ck.XPath("/html/body/div/div/div/div[3]/div[4]/span/div/div[1]/div[4]/div[2]/div[2]/span"), 0) Then
Set TDados = Sheets("Coleta dados").ListObjects("Tbextrai")
Set novodado = TDados.ListRows.Add
novodado.Range(1, 1).Value = driver.FindElementByXPath("//*[@id=""app""]/div[3]/div[4]/span/div/div[3]/div[2]/div[1]/div[2]/div[1]/span", 0).Text
novodado.Range(1, 2).Value = driver.FindElementByXPath("//*[@id=""app""]/div[3]/div[4]/span/div/div[3]/div[2]/div[1]/div[2]/div[2]/span", 0).Text
novodado.Range(1, 3).Value = driver.FindElementByXPath("/html/body/div/div/div/div[3]/div[2]/div[2]/div[2]/div[1]", 0).Text
novodado.Range(1, 4).Value = driver.FindElementByXPath("/html/body/div/div/div/div[3]/div[2]/div[2]/div[2]/div[3]", 0).Text
novodado.Range(1, 5).Value = driver.FindElementByXPath("/html/body/div/div/div/div[3]/div[4]/span/div/div[3]/div[2]/div[1]/div[3]/div[2]/div[1]/span[1]", 0).Text
novodado.Range(1, 6).Value = driver.FindElementByXPath("/html/body/div/div/div/div[3]/div[4]/span/div/div[3]/div[2]/div[1]/div[3]/div[2]/div[1]/span[3]", 0).Text
novodado.Range(1, 7).Value = driver.FindElementByXPath("/html/body/div/div/div/div[3]/div[4]/span/div/div[3]/div[2]/div[1]/div[3]/div[3]/div[1]/span[1]", 0).Text
novodado.Range(1, 8).Value = driver.FindElementByXPath("/html/body/div/div/div/div[3]/div[4]/span/div/div[3]/div[2]/div[1]/div[3]/div[3]/div[1]/span[3]", 0).Text
novodado.Range(1, 9).Value = driver.FindElementByXPath("/html/body/div/div/div/div[3]/div[4]/span/div/div[3]/div[2]/div[1]/div[3]/div[1]/div[1]/span[1]", 0).Text
novodado.Range(1, 10).Value = driver.FindElementByXPath("html/body/div/div/div/div[3]/div[4]/span/div/div[3]/div[2]/div[1]/div[3]/div[1]/div[1]/span[3]", 0).Text
novodado.Range(1, 11).Value = driver.FindElementByXPath("/html/body/div/div/div/div[3]/div[4]/span/div/div[3]/div[2]/div[1]/div[3]/div[7]/div[1]/span[1]", 0).Text
novodado.Range(1, 12).Value = driver.FindElementByXPath("/html/body/div/div/div/div[3]/div[4]/span/div/div[3]/div[2]/div[1]/div[3]/div[7]/div[1]/span[3]", 0).Text
novodado.Range(1, 13).Value = driver.FindElementByXPath("/html/body/div/div/div/div[3]/div[4]/span/div/div[3]/div[2]/div[1]/div[3]/div[5]/div[1]/span[1]", 0).Text
novodado.Range(1, 14).Value = driver.FindElementByXPath("/html/body/div/div/div/div[3]/div[4]/span/div/div[3]/div[2]/div[1]/div[3]/div[5]/div[1]/span[3]", 0).Text
novodado.Range(1, 15).Value = driver.FindElementByXPath("/html/body/div/div/div/div[3]/div[4]/span/div/div[3]/div[2]/div[1]/div[3]/div[8]/div[1]/span[1]", 0).Text
novodado.Range(1, 16).Value = driver.FindElementByXPath("/html/body/div/div/div/div[3]/div[4]/span/div/div[3]/div[2]/div[1]/div[3]/div[8]/div[1]/span[3]", 0).Text
novodado.Range(1, 17).Value = driver.FindElementByXPath("/html/body/div/div/div/div[3]/div[4]/span/div/div[3]/div[2]/div[1]/div[3]/div[9]/div[1]/span[1]", 0).Text
novodado.Range(1, 18).Value = driver.FindElementByXPath("/html/body/div/div/div/div[3]/div[4]/span/div/div[3]/div[2]/div[1]/div[3]/div[9]/div[1]/span[3]", 0).Text
novodado.Range(1, 19).Value = driver.FindElementByXPath("/html/body/div/div/div/div[3]/div[2]/div[2]/div[2]/div[2]/div[1]/span/span[1]", 0).Text
ActiveCell.Offset(1, 0).Select
Else
Planilha3.Select
If Range("F23").Value <> "" Then
Set r = ActiveCell.Rows
Range("F23").Select
ActiveCell.Copy
r.Select
ActiveCell.PasteSpecial
Rows("23:23").Delete
Else
Set TDados = Sheets("Coleta dados").ListObjects("Tbextrai")
Set novodado = TDados.ListRows.Add
novodado.Range(1, 1) = "Trocar Link"
novodado.Range(1, 2) = "Trocar Link"
ActiveCell.Offset(1, 0).Select
End If
End If
Loop1:
Loop
driver.Quit
End Sub