Advertisement
Guest User

Untitled

a guest
Sep 10th, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Function Scrape(url As String) As String
  2.   Dim Browser As InternetExplorer
  3.   Dim Document As htmlDocument
  4.   Set Browser = New InternetExplorer
  5.    
  6.   Browser.Visible = False
  7.   Browser.navigate url
  8.  
  9.   Do While Browser.Busy And Not Browser.readyState = READYSTATE_COMPLETE
  10.       DoEvents
  11.   Loop
  12.  
  13.   Scrape = Document.getElementById("receipt").getElementByTagName("a").href
  14.  
  15.   Set Document = Nothing
  16.   Set Browser = Nothing
  17. End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement