ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro to navigate through a Java Web-Page (https://www.excelbanter.com/excel-programming/444655-re-macro-navigate-through-java-web-page.html)

ron

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





All times are GMT +1. The time now is 03:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com