HTML/VBA Click event not firing

Question

This is my first time posting a question on StackOverflow. Up until now I have been able to resolve most of my questions via VBA help forums.

My issue is pretty simple. I have an automated data pull in which I need to export data. I have been successful with this in the past, but this one is slightly different.

The HTML for the button I am trying to click to generate the export is this:

  <a id="ReportViewer1_ctl01_ctl05_ctl01" 
    style="font-family: Verdana; font-size: 8pt; color: Gray; text-decoration: none; 
    cursor: default;" href="#" title="Export"
 onmouseout="TextLinkReportViewer1_ctl01_ctl05_ctl01.OnLinkNormal();"
 onmouseover="TextLinkReportViewer1_ctl01_ctl05_ctl01.OnLinkHover();" 
    onclick="if (document.getElementById('ReportViewer1_ctl01_ctl05_ctl00').selectedIndex == 0) return false; 
    if (!ClientToolbarReportViewer1_ctl01.HandleClientSideExport()) __doPostBack('ReportViewer1$ctl01$ctl05$ctl01','');return false;">Export</a>

I have tried several ways to click to no avail.

I have tried several ways to click to no avail. Please help! <-- What have you tried so far? — David Zemens
– David Zemens, Commented Oct 2, 2013 at 16:21

Santosh · Accepted Answer · 2013-10-02 18:29:38Z

2

FireEvent is used to trigger the event attached to any element.

IE.document.getElementById("ReportViewer1_ctl01_ctl05_ctl01").click()
IE.document.getElementById("ReportViewer1_ctl01_ctl05_ctl01").FireEvent("onclick")

answered Oct 2, 2013 at 18:29

Santosh

12.4k4 gold badges43 silver badges74 bronze badges

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

Comments

Tim Williams · Accepted Answer · 2013-10-02 18:00:33Z

1

IE.document.getElementById("ReportViewer1_ctl01_ctl05_ctl01").click()

answered Oct 2, 2013 at 18:00

Tim Williams

169k8 gold badges104 silver badges143 bronze badges

Collectives™ on Stack Overflow

HTML/VBA Click event not firing

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related