Yesterday I was working with web scraping ..
(Found this on youtume: https://www.youtube.com/watch?v=dShR33CdlY8&t=670s)
It was working well and i did some progress but suddenly I got a Excel crash and after that I only get "access denied" ?!
I just can't get it to work anymore. Anyt tip what happend and how to fix it ?
I tryint to read files (names) from a SharePoint site (https)
References are loaded. Can a reference brake down??? Error on ".send" row.
(Found this on youtume: https://www.youtube.com/watch?v=dShR33CdlY8&t=670s)
It was working well and i did some progress but suddenly I got a Excel crash and after that I only get "access denied" ?!
I just can't get it to work anymore. Anyt tip what happend and how to fix it ?
I tryint to read files (names) from a SharePoint site (https)
References are loaded. Can a reference brake down??? Error on ".send" row.
Code:
Sub BrowseToWebPage()
Dim xmlpage As New MSXML2.XMLHTTP60
Dim doc As New MSHTML.HTMLDocument
Dim htmltables As MSHTML.IHTMLElementCollection
xmlpage.Open "GET", "https://sharepoint .. bla-bla .. Forms/AllItems.aspx", False
xmlpage.send
End Sub