\Hope it will help you
For Each oHTML_Element In HTMLDoc.getElementsByTagName("Export") If oHTML_Element.Type = "submit" Then oHTML_Element.Click Exit For End If Next From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Don Flak Sent: Saturday, June 11, 2011 5:36 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro to navigate through a Java Web-Page Options No, but the site does acquire my login credentials through the workstation. We utilize a single sign on, so when I log on to my work station, it maintains my credentials and permits access to several internal servers. As I said, I don't have a problem with the code I wrote that gets me to the page and the report I need, I simply can't get over the last hurdle and "click" the export button. Thanks, Don On Sat, Jun 11, 2011 at 12:53 AM, Rajan_Verma <rajanverma1...@gmail.com> wrote: Is it HTTPS:// site? -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Don Sent: Saturday, June 11, 2011 12:18 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Macro to navigate through a Java Web-Page Options I have to log onto our corporate reporting portal, click through several folders, execute data queries, export the data to a .csv file and then run some reports from that data. I have the code written to get to the the web-apge I need, and prepare the report for exporting. There is a button at the bottom of the page that simply is titled Export but it is a java enabled button. I need the code that would in essence, click the button and start the export. Any suggestions would be greatly appreciated. I can't post a link to the site because it is an internal, secured site. Thanks -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel