I have a project at the company, where i should collect data from an intern website und write them down in excel. Therefore i tried web scraping with excel vba. My Code looks like this:
Sub WebScr()
Dim Internet As InternetExplorer
Set Internet = New InternetExplorer
Internet.Visible = True
Internet.navigate ("intern company link")
Do While Internet.readyState <> READYSTATE_COMPLETE:
Loop
MsgBox Internet.LocationName
End Sub
When i try the same thing with a different link it works. Is there maybe a problem with the internal server? Can i fix this with Excel VBA or should i try it different?
Thank you very much
Aucun commentaire:
Enregistrer un commentaire