Selenium VBA chrome

Question

I have read all the former posts to find the solution but I am still struggling with Selenium for VBA.

I would like to click on a button called "telecharger la page". The HTML code is below :

<tbody class="template-list">
<tr id=":y" class="goog-container">
<td>
<i class="icon foundicon-down-arrow pointer download-button general" title="Télécharger la table">
</i>

I have tried with this VBA code but it does not work...

bot.FindElementsByXPath("//tr[@id=':y']").Click.FindElementsByTag("Télécharger la table").Click

Could somebody help me?

thanks!

score 1 · Answer 1 · answered Mar 20 '20 at 16:57

1

Here is the xpath that you can use.

//tr[@id=':y']//i[@title='Télécharger la table']

And you code should be

bot.FindElementByXpath("//tr[@id=':y']//i[@title='Télécharger la table']").click

answered Mar 20 '20 at 16:57

supputuri

13,644
2
21
39

Make sure you use `FindElementByXpath` not `FindElementsByXpath`. – supputuri Mar 20 '20 at 16:58

score 0 · Answer 2 · answered Mar 20 '20 at 16:52

0

It seems that you are finding an element in another element. That can be achieved using xpath only. Try using below xpath:

bot.FindElementsByXPath("//tr[@id=':y']/i").Click

answered Mar 20 '20 at 16:52

Deepak Kumar

106
7

score 0 · Answer 3 · answered Mar 20 '20 at 16:57

To click on the elelemtn you can use either of the following Locator Strategies:

Using FindElementByCss:

bot.FindElementByCss("tr.goog-container[id$='y']>td>i.icon.foundicon-down-arrow.pointer.download-button.general[title='Télécharger la table']").Click

Using FindElementByXPath:

bot.FindElementByXPath("//tr[@class='goog-container' and contains(@id, 'y')]/td/i[@class='icon foundicon-down-arrow pointer download-button general' and @title='Télécharger la table']").Click

Selenium VBA chrome

3 Answers3