Hi there
Really struggling with this one, so any help really is greatly appreciated (I have lost hours of my day to this already).
I have used the code below a good number of times to extract the entire HTML source code of a webpage and pass it to a string in Excel VBA.
Function GetHTML(url As String) As String
Dim HTML As String
With CreateObject("MSXML2.XMLHTTP")
.Open "GET", url, False
.send
GetHTML = .responseText
End With
End Function
The problem I have is that I now need the entire HTML source code for a webpage which requires a login. The above code gets the HTML for the page which is displayed on going to the URL when I am not logged into the site - I need the source code for the same URL, but post login.
I am thinking that something involving
CreateObject("InternetExplorer.Application")
may be needed, but any thoughts are greatly appreciated. I am happy to go into Internet Explorer prior to running the code to ensure that I am logged into the site.
Many thanks
Andrew
Bookmarks