Excel VBA Selenium click second button

Question

I am trying to program in Excel VBA with selenium to click on a button but the web (http://app.bde.es/rss_www/) has two buttons with the same "Type" and "Class".

<input type="button" class="boton" value="Consultar en PDF" onclick="irAConsulta(document.getElementById('entidad').value, document.getElementById('objetivo').value, document.getElementById('paisRegistro').value, document.getElementById('sector').value, document.getElementById('ejercicio').value, document.getElementById('dimension').value, document.getElementById('pais').value, '0');">

<input type="button" class="boton" value="Consultar en EXCEL" onclick="irAConsultaExcel(document.getElementById('entidad').value, document.getElementById('objetivo').value, document.getElementById('paisRegistro').value, document.getElementById('sector').value, document.getElementById('ejercicio').value, document.getElementById('dimension').value, document.getElementById('pais').value, '0');">

I need to click on the second one to download the data in Excel.

If I type :

OBJ.FindElementByClass("button").Click

This Clicks on the first one (the PDF), how can I click on the second one for the excel data?

score 2 · Answer 1 · answered Feb 15 '22 at 17:32

2

You can locate that element with XPath or CSS Selector.
By XPath:

OBJ.FindElementByXPath("//input[@value='Consultar en EXCEL']").Click

By CSS Selector:

OBJ.findElementByCssSelector("input[value='Consultar en EXCEL']").Click

answered Feb 15 '22 at 17:32

Prophet

32,350
22
54
79

score 0 · Accepted Answer · answered Feb 15 '22 at 21:04

FindElementBy* will always return the first matching element. So the locator strategy you have used always returned the first matching element, which is the control for downloading the data in PDF format.

To identify the element for downloading the data in Excel format you need to identify the WebElement uniquely and you can use either of the following Locator Strategies:

Using FindElementByCss and onclick attribute:

OBJ.FindElementByCss("input[onclick^='irAConsultaExcel']").Click

Using FindElementByCss and value attribute:

OBJ.FindElementByCss("input[value='Consultar en EXCEL']").Click

Using FindElementByXPath and onclick attribute:

OBJ.FindElementByXPath("//input[starts-with(@onclick, 'irAConsultaExcel')]").Click

Using FindElementByXPath and value attribute:

OBJ.FindElementByXPath("//input[@value='Consultar en EXCEL']").Click

Excel VBA Selenium click second button

2 Answers2