Need to determine the export button tag name or Id of a Sun Java button to download the displayed WEB page. The web page is a SUN application generated page so we do not have access to 'any' internal names or tags on the page.
Below is the code we have to open and wait for the page to complete loading.
Code:
Sub ztestfile()
Dim oIE As Object
Dim cURL As String
Dim lLoadSucccess As Boolean
Dim nButton As Integer
lLoadSuccess = False
cURL = "[URL unfurl="true"]http://internalwebsite.mil"[/URL]
Set oIE = CreateObject("InternetExplorer.Application")
oIE.Visible = True
lLoadSuccess = LoadWebPage(oIE, cURL) ' wait for page load
' click export button to begin download process
' ????? how to click button ????
' process exported report and re-distributed via e-mail
end sub
Any ideas on how to click the export button or determinte its name/ID? Below is the VBA command/s we are attempting to use. Maybe another method?
oIE.Document.getElementsByName( <buttonName> ).click
oIE.Document.getElementsByID( <buttonID> ).click
Searched may web sites looking for examples to no avail. Everthing we have tried returns and error or empty variable.
Without being able to click the button the project is dead.
Any help would be greatly appreciated.
D. Buckman
US Army Corps of Engineers, Omaha
Learn from the past, Live in the present, Create the future