VB for applications accessing data from web pages

I have an application in MS Access which needs to extract text data from a Web site.

How can I use VB (in MS Access) to link to the URL and get access to the underlying HTTP (so I can parse for the data I want )




Answer this question

VB for applications accessing data from web pages

  • enric vives

    I've done the same thing in Excel, using the Microsoft HTML Object Library and Microsoft Internet Controls to parse HTML. In the VBA project (Tools>References) set references to these two libraries.
    I found the following thread useful also: extracting data from an html page

  • kennm

    Thanks for the pointer. I've ended up doing the parsing myself, buts it all working fine.

  • VB for applications accessing data from web pages