How to web scrape using Access, Excel, or Word?

[Guest]

I have data that is located in many places. I have to copy and paste this
data to one excel file spreadsheet in order to create a report. I would like
to automate this process, and being that I'm not very knowledgeable, I was
wondering if someone has any tips. I think web scraping will do the trick,
but I don't know where to start.

 

[alex_f_il]

You can try SWExploreAutomation SWEA (http://webunittesting.com).
SWEA greatly simplifies development of scraping solutions.

 

[Fred Boer]

Hello Jeremy:

I'm not sure if this is what you need, but you might try experimenting with
the Web Browser ActiveX control that comes with Microsoft Access. I once
used it, (with some code kindly provided by Doug Steele), to scrape
information off of a web page. It was pretty slick, as I recall...

I can't find the database in which I used this, but if you are interested, I
could look for it. In any case, if you are willing to work through a long
thread, do a Google groups search with the following:

using a web browser control fredboer1

This will get you the thread in which Doug describes how to scrape the web
page in the browser control...

HTH
Fred Boer

 

[Fred Boer]

Hello again... It was easier to find than I thought.

The following is the code to scrape the text from a web page, assuming the
web browser control is called "ocxBrowser"...

strGetCatData = Me.ocxBrowser.Document.documentElement.innerText
msgbox strGetCatData

Fred