LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
ron ron is offline
external usenet poster
 
Posts: 118
Default Macro to navigate through a Java Web-Page

Hi Don...It's hard to figure it out without being able to look at the source code, but hopefully one of the following approaches will work. Take a look at the source code behind the page and search for "Export". The code around there will give you a clue as to what you need to do. Often, the button will have a name (an ID), if so the following construction should work

IE.Document.getElementByID("button name").click

If the code reads such that when the button is clicked a form is submitted, then use a construction like

ie.document.forms(enter a number or a "name").submit

Sometimes the button is an image. If so, use something like

If ie.Document.all.Item(x).tagname = "IMG" Then

to identify the item number for the button image and then

ie.document.all.Item(number).Click

should work. Again, it's hard to say exactly what to do without seeing the code, but hopefully this will get you going in the right direction...Ron



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to navigate through a Java Web-Page Don[_3_] Excel Programming 1 June 11th 11 01:55 AM
Web Query (Java Page) Ron Rosenfeld Excel Programming 5 August 26th 10 08:39 PM
Navigate on Web Page tp803 Excel Programming 4 September 8th 09 07:34 PM
Ctrl+Page Down to navigate sheets TimT Excel Discussion (Misc queries) 1 May 30th 07 02:21 PM
Execute Excel Macro using Java chrischern Excel Programming 0 June 29th 04 04:09 AM


All times are GMT +1. The time now is 09:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"