Advertisement
Guest User

Untitled

a guest
May 29th, 2018
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.64 KB | None | 0 0
  1. Sub DownloadIntraDayReport()
  2.  
  3. Dim ie As New InternetExplorer
  4.  
  5. ie.navigate "weblink"
  6.  
  7. ie.Visible = True
  8.  
  9. While ie.Busy
  10. DoEvents
  11. Wend
  12.  
  13. Do
  14. Loop Until ie.readyState = READYSTATE_COMPLETE
  15.  
  16. Set HTMLDoc = ie.document
  17.  
  18. ie.document.getElementById("_58_login").Value = "username"
  19.  
  20. ie.document.getElementById("_58_password").Value = "password"
  21.  
  22. 'ie.document.form().submit
  23.  
  24. For Each MyHTML_Element In HTMLDoc.getElementsByTagName("input")
  25.  
  26. If MyHTML_Element.Type = "submit" Then MyHTML_Element.Click
  27.  
  28. Next
  29.  
  30. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement