I am from Portugal, and since I moved to another country, I cannot access the URL
I can if I use a VPN connection with a portuguese server, nevertheless when trying to scrap data from that URL, my vba code cant navigate to the page.
Any thoughts ?
I can if I use a VPN connection with a portuguese server, nevertheless when trying to scrap data from that URL, my vba code cant navigate to the page.
Any thoughts ?
Code:
Dim ie As Object
Dim doc As HTMLDocument
Dim strPath As String
Dim oElement As Object
Set ie = New InternetExplorerMedium
strPath = "https://www.e-leiloes.pt/info.aspx?lo=LO1063072023"
ie.Navigate strPath
ie.Visible = True
Do While (ie.Busy) Or (ie.ReadyState <> 4)
DoEvents
Loop
workStr = ie.Document.getElementsByClassName("InfoBemPaginaColuna03")(0).innerText