KiwiAppsDesigner


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 )





Re: VB for applications accessing data from web pages

Navajo


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





Re: VB for applications accessing data from web pages

KiwiAppsDesigner

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