Web scrapping - launch website in internet explorer using vba

Web scrapping - launch website in internet explorer using vba

Sub openwebsite()
    
    Dim ie As InternetExplorer
    
    Set ie = New InternetExplorer
    
    ie.Visible = True
    ie.Navigate "https://quotes.toscrape.com/"
    
    Do While ie.ReadyState <> READYSTATE_COMPLETE Or ie.Busy = True: Loop
    Application.Wait Now() + TimeValue("00:00:03")
    
    
    Debug.Print ie.LocationName, ie.LocationURL
    
    ie.Quit
End Sub

Subscribe my Channel

Akash Vishwakarma

Hi This is Akash Vishwakarma. I am working as software developer. I have knowledge in VBA, SQL Server, Python. I have developed this website from Django Framework for given traning.