Guest User

Untitled

a guest
Jul 16th, 2018
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. Sub GO_Click()
  2.  
  3. Const Url$ = "url_removed"
  4.  
  5. Dim UserName As String, Password As String, LoginData As Workbook
  6. UserName = "urn"
  7. Password = "Pa$$"
  8.  
  9. Dim ie As Object
  10. Set ie = CreateObject("InternetExplorer.Application")
  11.  
  12. With ie
  13.  
  14. .navigate Url
  15. ieBusy ie
  16. .Visible = True
  17.  
  18. Dim oLogin As Object, oPassword As Object
  19. Set oLogin = .document.getElementsByName("ecp_param_userId")(0)
  20. Set oPassword = .document.getElementsByName("ecp_param_password")(0)
  21.  
  22. oLogin.Value = UserName
  23. oPassword.Value = Password
  24. .document.forms(0).submit
  25.  
  26. End With
Add Comment
Please, Sign In to add comment