excel vba

When automating  #angularjs #reactjs

  • Using Wait and sleep right after intranet page 1
  • navigate “intranet page 2” End With End Sub
  • Ending the With Loop right after intranet page 1, and calling objie.navigate after the loop
  • WebSite = “intranet IP ” With objie ‘Code to login .navigate “intranet page 1” ‘Shell script kicks in to enter login credentials for popup ‘ReadyState is always 1 while running macro full speed .
  • If I run this in Debug mode and Step Through the program, ReadyState does reach 4, and I am able to get the code to reach intranet page 2.

I’m trying to automate a login and navigate procedure to my company’s intranet using Excel VBA via an IE Object. After logging in and navigating to another page, a Windows Security popup prompts for administrative credentials. I’m using calling a Shell script at the beginning of the code to listen and use Sendkeys to input the credentials when it pops up. After dismissing the popup, I’m finding that I can no longer control the original IE window.

@ng_real_ninja: When automating #angularjs #reactjs

I’m trying to automate a login and navigate procedure to my company’s intranet using Excel VBA via an IE Object. After logging in and navigating to another page, a Windows Security popup prompts for administrative credentials. I’m using calling a Shell script at the beginning of the code to listen and use Sendkeys to input the credentials when it pops up. After dismissing the popup, I’m finding that I can no longer control the original IE window.

So in this code, “intranet page 2” is never reached. However, if I run this in Debug mode and Step Through the program, ReadyState does reach 4, and I am able to get the code to reach intranet page 2.

I’ve tried:

But none of the above works. Could anyone shed some light on what the issue is?

excel vba