VBA, Internet Explorer and Javascript

65 Views Asked by At

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)

0

There are 0 best solutions below