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

You might also like More from author

Comments are closed, but trackbacks and pingbacks are open.