\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
