Read a WebPage Data

[Milton Zafra Lizcano]

Good Night,

I need to read the data displayed in a WebPage, or copy some values fron the
webpage to a Form in Access.

Somebody can help me or give me an idea to do this ?

Thank you,

Milton Zafra L
Bogota - Colombia

 

[David Lloyd]

Milton:

Reading data from an HTML file is a text string manipulation excercise since
the HTML is text based. Consequently, you will use many of the string
manipulation functions, the most popular being the InStr function for
locating various points in the HTML file and the Mid function for removing
the text forward of the position located with the InStr function. The key
is to find unique words or HTML tags to move to the appropriate location(s)
within the HTML file to extract the data cleanly.

If you need to read the HTML file from the file system you can use the
FileSystemObject and the TextStream object. From there it is just basic
string manipulation to find the data you want and extract it cleanly.

David Lloyd
Lemington Consulting
http://lemingtonit.com