How to access an HTML document

[PeteG]

Hi,
I'd like to read the contents of an HTML document into a recordset (or an array). Does anyone have a simple way that I can get started, eg how to make a reference to the actual document and maybe move through the various 'elements' of an HTML doc? Or does anyone have any useful links for this sort of thing?

I'm assuming I'll be using the MSHTML object library but I can't quite work out where to begin....

Many thx
Pete

 

[Guest_imported]

Reference the Microsoft Scripting Runtime

Dim oFilesystem As Scripting.FileSystemObject
Dim oHTMLFile As Scripting.TextStream
Dim sHTMLFile As String

Set oFilesystem = New Scripting.FileSystemObject
Set oHTMLFile = oFilesystem.OpenTextFile("yourfile.htm")

sHTMLFile = oHTMLFile.ReadAll

Now you can analyse the string and e.g. search for &quot;<&quot;