VBA IE On-Click Command for ASP Page

redbaron06

New Member
Joined
Aug 6, 2010
Messages
44
Hi all,

I was wondering if anyone knew a way to generate an on-click command for the bolded ASP line below. When clicked it exports data to an XML sheet that can be opened by Excel. I have tried various methods such as IE.document.all("USDPersons_NewRow").Click and IE.document.all("USDPersons_PCTableFunctions").Click after the IE.Navigate to the page. Any suggestions? Thanks in advance!

input type="hidden" id="USDPersons_NewRow" name="USDPersons_NewRow" value="">
******** language="javascript">
var USD1_USDPersons_chkTableAr = new Array(0,1,2,2,3,5,8,13,19,22);
var USD1_USDPersons_chkTable_childAr = new Array();
var USDPersons_Toggle_Rows = Array();
*********>
<table
width="100%">
<tr><td>
<SPAN class="smlink" align="left">
This tab is…..<SPAN><div id="USDPersons_div" style="{display:block;}"><table cellspacing="5%" id="USDPersons_PCTableFunctions" class="PCTableFunctions"><tr><td><SPAN style="CURSOR: hand" align="left"><A *******="Javascript:if (okToLeave('output')) { document.getElementById('Form1').target='_blank';document.getElementById('disablefunctionality_fl').value=false;document.getElementById('validate_fl').value=false;__doPostBack('USDPersons','OutputPage^Excel^-1');document.getElementById('disablefunctionality_fl').value=true;document.getElementById('validate_fl').value=true;document.getElementById('Form1').target='_self'; }"><img src="images/excel.gif" title="Export data in Excel" border="0"></A></SPAN></td>
<td><SPAN style="CURSOR: hand" align="left"><A *******="Javascript:showPopUp('Help/VICA_Help.htm?idx=II._Volunteer_Maintenance.htm','USDPersons');"><img src="images/help.gif" title="Help Window" border="0"></A></SPAN></td>
</tr></table>
 
Last edited:

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Forum statistics

Threads
1,224,594
Messages
6,179,792
Members
452,942
Latest member
VijayNewtoExcel

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