Saving Web Page to EXCEL or ????

[TURNERMICH]

I am using the following to capture data from a web page.

Openfile="

http://www.

etc .html

IEObj.Navigate "" & Openf
IEObj.Visible = False

Private Sub IEObj_DocumentComplete(ByVal pDisp As Object, URL As Variant)


Print #1, IEObj.Document.documentelement.outertext


The pages are very standard in format, but are not tables.

Is there any way of capturing the contents of the web page to say EXCEL or ??, so that the text contents
are in some form of consistant format.

At the moment i have to parse each line and work all the data out. ( a lot of work)!!

Appreciate any advice

 

[TURNERMICH]

Even saving it in html text would be better than outertext
Is this possible.

 

[TURNERMICH]

Have worked out. innerhtml
This gives me the page in some sort of consistant format

Please ignore the question !!!!