Advertisement
Guest User

Untitled

a guest
Dec 17th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Function internetExplorer()
  2.  
  3.  Set ie = CreateObject("InternetExplorer.Application")
  4.     With ie
  5.         .navigate "https://de.wikipedia.org/wiki/VfB_Stuttgart"
  6.         .Visible = True
  7.     End With
  8.     Do Until Not ie.Busy And ie.readyState = 4
  9.         DoEvents
  10.     Loop
  11.  
  12. Debug.Print ie.document.getelementsbyclassname("firstHeading")(0).innertext
  13.  
  14. Range("A1").Value = ie.document.getelementsbyclassname("firstHeading")(0).innertext
  15.  
  16. End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement