vendredi 5 novembre 2021

The called object is disconnected from its clients in Excel VBA - Webscraping

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