As depicted in the picture below, I want to access the data within the red box. The main class has 5 "row" elements enclosed within it. How can I display those values on in an excel cell using Selenium Chromedriver.
Set myColl = WPage.FindElementsByClass("row")
Set myColl = WPage.FINFelementsbyclass("input-form-column")(1).FindElementsByClass("row")
Sheets("Sheet1").Select
For I = 1 To myColl.Count
RawTxt = myColl(I).FindElementsByTag("h6")(1).Text
mySplit = Split(Replace(RawTxt, Chr(34), "", , , vbTextCompare) & " " & Chr(10), Chr(10), , vbTextCompare)
Cells(2, I).Resize(UBound(mySplit) + 1, 1).Value = Application.WorksheetFunction.Transpose(mySplit)
Next I
Private ch As Selenium.ChromeDriver
Sub Test()
Set ch = New Selenium.ChromeDriver
ch.Get "https://www.uplandoptimizer.com/"
ch.FindElementsByClass("btn")(1).Click
ch.FindElementsByClass("form-control")(1).SendKeys ("username")
ch.FindElementsByClass("form-control")(2).SendKeys ("password")
ch.FindElementsByClass("btn")(1).Click
Set a = ch.FindElementsByClass("input-form-column.username-col")(4).FindElementsByClass("row")
Cells(1, 1).Value = a.FindElementsByTag("h6")(1).Text
End Sub
ch.FindElementsByClass("btn")(1).Click
ch.Wait 2000 ‘Wait 2 secs ***
Set a = ch.FindElementsByClass("input-form-column.username-col")(1).FindElementsByClass("row") 'collection of the "row"
Cells(1, 1).Value = a(4).FindElementsByTag("h6")(1).Text
ch.Wait 5000
Debug.Print ">>>>"
Set A = ch.FindElementsByClass("input-form-column")
Debug.Print A.Count
If A.Count > 0 Then
Debug.Print ch.FindElementsByClass("input-form-column").Attribute("innerHTML")
End If
Debug.Print "<<<<"