Advertisement
Guest User

Untitled

a guest
Aug 27th, 2016
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.40 KB | None | 0 0
  1. Sub Macro()
  2. Dim IE As New InternetExplorer
  3. IE.Visible = True
  4. IE.navigate "https://skrendu.lt/lt/flights/VNOc-OPOc/2016-09-15/1"
  5.  
  6. Do
  7. DoEvents
  8. Loop Until IE.readyState = READYSTATE_COMPLETE
  9. Application.Wait (Now() + TimeValue("00:00:010"))
  10.  
  11. Dim Doc As HTMLDocument
  12. Set Doc = IE.document
  13. IE.Quit
  14.  
  15. Dim sTR As String
  16. sTR = Doc.getElementsByClassName("ng-binding ng-scope")(0).innerText
  17. Range(A1) = sTR
  18.  
  19. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement