I am using the following to capture data from a web page.
. etc .html
IEObj.Navigate "" & Openf
IEObj.Visible = False
Private Sub IEObj_DocumentComplete(ByV
al pDisp As Object, URL As Variant)
Print #1, IEObj.Document.documentele
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