I'm currently working on a VBA automatisation between Excel Files and Oracle Data base via APEX using Internet Explorer but the last Oracle update give me some issues.
(I'm still using internet explorer instead of another web browser because I can't install any external software on my computer at work.)
At one point my VBA code was suppose to "Click" on a button launching Java Script for Log in.
This is the HTML code I can read on my Internet Explorer Browser :
<a href="javascript:apex.submit(%7Brequest:'LOGIN'%7D);">Connexion</a>
Any advise or Ideas ?
With my VBA code, this is what I did
Set ie = New InternetExplorerMedium
ie.Visible = True
ie.Navigate ("ToMyURL")
Set idoc = ie.Document
Set ElementCol = idoc.getElementsByTagName("a")
For Each Link In ElementCol
If Link.innerHTML = "Connexion" Then
Link.Click
Exit For
End If
Next Link
But this code is not working anymore.
Even if I'm not using VBA, if I'm loading the webpage with Internet Explorer, I can't interact with the "Connexion" button with my mouse neither. (it seems that internet explorer is not able to see and interact with javascript after the last update)