VBA macro: problem to click a button (with class) on internet website (through internet explorer)

Question

I have a problem to click on button on an internet website, I cannot display the full VBA code because it is about a sensitive website used on a professional environment.

What I would like that my excel macro does is to display the website desired (this part, my macro does it perfectly) , then I would like that my macro click on one specific button on this website, after inspecting the HTML code of this button, it returns me the following HTML code:

<div title="Export Datas" class="pExportdatas pButton"><span></span></div>

I have tried different instructions in VBA (please find them below) to click on this button but every time unsuccessfully (the macro does not perform this Action, the macro does not return me any error message but the button is unfortunately every time not clicked).

HTMLDoc.all("pExportdatas pButton").Click   
objIE.document.getElementById("pExportdatas pButton").Click
objIE.document.querySelector("button[class*= pExportdatas pButton]").Click

In case, someone knows the solution, it would be really super. Many Thanks in advance Xavi

QHarr · Accepted Answer · 2018-12-14 09:35:59Z

1

You can't have compound class names in a css selector. Try the following attribute = value selector

objIE.document.querySelector("[title='Export Datas']").click

Or

objIE.document.querySelector("div.pExportdatas.pButton").Click

If you get a not found error then make sure you have a proper wait before

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

and also check there is no parent frame/iframe to negotiate.

answered Dec 14, 2018 at 9:35

QHarr

84.5k14 gold badges58 silver badges105 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Xavi Over a year ago

thanks a lot QHarr for your reply and this tips, I tried your code but unfortunately, the button is not clicked yet...

QHarr Over a year ago

what is happening? Any error messages? You can also try objIE.document.querySelector("[title='Export Datas']").FireEvent("onclick")

Xavi Over a year ago

no error messages at all, it is just that the button is not clicked... I tried also objIE.document.querySelector("[title='Export Datas']").FireEvent("onclick") but same result, no error message but the button is not clicked.... there is probably something inside the html code related to this button which is more complex... When the button is clicked on this website, it should normally download an excel file...

QHarr Over a year ago

Upvotes welcome but you shouldn’t accept as answer as it may put other people off trying to answer. I will have another look later. In the meantime we may need to see more html.

Xavi Over a year ago

Thanks Qharr, I undid the acceptance of youranswer

Collectives™ on Stack Overflow

VBA macro: problem to click a button (with class) on internet website (through internet explorer)

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related