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