Grab HTML

[Guest]

Hi there.

I am currently working on a project, that when done, will "grab" a website's
html source, parse it for information, and then store this info in a table.

I am currently working on the automatic "grabbing" of the source code.

I have researched a couple functions through google.

But I am wondering if anyone has a proven method that works with vba?

Thanks.
-State

 

[Douglas J Steele]

Take a look at my November, 2003 "Access Answers" column in Pinnacle
Publication's "Smart Access" for one approach.

You can download the column (and sample database) for free from
http://www.accessmvp.com/DJSteele/SmartAccess.html

(Unfortunately, since the website being used has changed since the article
was originally written, the demo no longer works as advertised, but
hopefully you'll be able to figure out what it was doing)

 

[Guest]

Perfect.

Works amazing.

Thanks, your help is very much appreciated.
-State