I'm trying to extract some web information Via selenium, the point I'm catching is this: I can direct information from the selenium searched on the internet and save it inside a specific cell, however what I need would be, that in a query two fields were searched and the information was thrown to only one cell, separating them by space. Any suggestions?
Here's an example:
'Logradouro
Sheets("CONSULTA").Cells(Lin, 6) = selenium.findElementByXPath("//tr[7]/td").Text
I tried it as follows:
'Logradouro
Sheets("CONSULTA").Cells(Lin, 6) = selenium.findElementByXPath("//tr[7]/td", "//tr[8]/td").Text
But without success, the information in this way appears blank.