Clicking button without ID on a web page with vba

Jishnu Surendran

New Member
Joined
Jul 29, 2013
Messages
32
I've a button on a web page that I am trying to click using vba. The button exports the table to excel; it does not have any text but only the excel logo. Below is the html of the button retrieved using the 'inspect element' property of the web page.

< a class="x1" tab index="0" aria-controls="print_all">...</a> (event)
.... is the span
(event) is the event of the button
x1 is just an indicative text

I've tried .getelementsbyclassname("x1").click but nothing is happening, the button doesn't have an ID either. There is another button to the left which is clicked for printing out the table.

I've opened the webpage, logged in a retrieved the table; buttons where clicked wherever necessary all using vba except this which is bugging me for sometime now.

Is there a way to click this button using vba?
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,224,817
Messages
6,181,144
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top