Using VBA and interacting with MSIE, how do I refer to the InternetExplorer object which contains the body text of a typical web page (in order to select, copy, and paste the text into Excel)? This is what I have so far (all am I able to do is navigate to the URL):
Dim xxxxxx As Object
Set xxxxxx = CreateObject("InternetExplorer.Application"
With xxxxxx
.navigate (" .Visible = True
'??? Refer to InternetExplorer object containing body text'
'??? copy text ???
End With
'Paste page text contents into Excel'
End Sub
Dim xxxxxx As Object
Set xxxxxx = CreateObject("InternetExplorer.Application"
With xxxxxx
.navigate (" .Visible = True
'??? Refer to InternetExplorer object containing body text'
'??? copy text ???
End With
'Paste page text contents into Excel'
End Sub