Run-Time Error 32 InvalidSelectorError (Reference A Cell In Selenium)

[mmbhatti]

Hello Excel Experts ;
I am scrapping some data from webpage. Data is to fetch one by one according to the values stored in column A of osh sheet. For this, I write a selenium command of FindbyXpath in a loop. Take a look at this code please

For index = 2 To osh.Cells(Rows.Count, 1).End(xlUp).Row

osh.Range("D" & index).Value = cd.FindElementByXPath("//td[.=osh.Cells(index,1).Value]/parent::tr/td[8]").Text

Next index

It is generating error

It means that The refer code osh.Cells(index,1).Value is not a correct way to get values from sheet column and put it an
cd.FindElementByXPath("//td[.="Formula To Refer"]/parent::tr/td[8]").Text

Can anyone guide me a correct way to write this?

 

[Anthony47]

Try using

osh.Range("D" & index).Value = cd.FindElementByXPath("//td[.=" & osh.Cells(index,1).Value & "]/parent::tr/td[8]").Text

 

[mmbhatti]

Try using

osh.Range("D" & index).Value = cd.FindElementByXPath("//td[.=" & osh.Cells(index,1).Value & "]/parent::tr/td[8]").Text

Waoo fantastic...
Thank you so much brother..
This simple Concatenation is working perfectly.

 

[Anthony47]

Thank you for the feedback
If that resolve the problem then it'd be better to mark the discussion as Resoved; see the procedure: Mark as Solution