When using VBA script to automate IE browser, the getElementsByClassName() method returns an array-like object of all child elements which have all of the given class name(s). So, we should find the special element according the array index.

Sample code as below

Public Sub ClickTest()

    Dim ie As Object

    Set ie = CreateObject("InternetExplorer.Application")
    With ie
        .Visible = True
        .Navigate2 "<web site url>"

        While .Busy Or .readyState <> 4: DoEvents: Wend

        ie.document.getElementsByClassName("button -tertiary")(0).Click
    End With
End Sub

The web page resource like this:

  <a class="button -tertiary" href="javascript:alert('hello')">Exportar Todo</a>

The above sample works well on my side (using IE 11), please check it and make sure we could use VBA to find the link in IE browser.

Then, change the javascript alert function to your export_all_to_excel() function, and check the code in the export_all_to_excel() function, make sure they all support IE browser.

Besides, here is another thread about Clicking on hyperlink with partial href on Internet Explorer using vba, you could refer it.

At the end I decided to use Selenium and Chrome to click the button and now it works! Thanks for your help guys

The VBA code is not responsible because it doesn’t work on IE 11 even not programmatically.

The button works with Chrome or Firefox but I cannot manage to use Selenium on my computer, it is throwing errors.

I asked the coding team of the website to tell me more precisely how this button was created on this link (Exportar todo) on this link https://bananadesk.com/transactions/incoming

Screen capture of the website:

<a class="button -tertiary" href="javascript:export_all_to_excel()">Exportar Todo</a>

If I inspect the html page, I see stuff like this:

o=null,i=null,a=/Version/(S+)s+Safari/;if(navigator.userAgent){var s=navigator.userAgent,c=s.match(a);c&&s.indexOf("Chrome")===-1&&s.indexOf("Chromium")===-1&&(o="Safari",i=c[1])}n.exports={agent:o,version:i,match:r}},{}],21:[function(t,n,e){function r(t,n){Var... 

Probably because their website is only supported on Chrome and Safari.

Here is the VBA code, it won’t click the button Exportar todo even though I am entering the If block properly:

For Each MyHTML_Element In HTMLDoc.getElementsByClassName("button -tertiary")
Debug.Print "button found"
MyHTML_Element.Click: Exit For
Next