VBA Web Scraping Kit

VBA Web Scraping Kit – easy scraping for Excel

1 Star2 Stars3 Stars4 Stars5 Stars (10 votes, average: 4.30 out of 5)
Loading...

The VBA Web Scraping Kit is a collection of VBA scripts that can be used for Web Scraping in a variety of scenarios making it possible to scrape almost any content. Why waste time Googling, writing scripts through trail and error when you can get a whole package of ready and tested script together with working live examples!

DOWNLOAD

What the VBA Web Scraping kit contains

The kit contains a collection of scripts that support most Web Scraping scenarios including both direct HTTP calls (GET and POST) and simulating browser interaction (via Internet Explorer).

Examples in the kit

The kit comes with several examples that showcase the capabilities and functions included in the Web Scraping kit. These examples include:

Scraping a HTML Table

HTML Tables and Divs are typical structures from which you need to scrape data sets. The first example shows how you can use Regex and XPath to loop through the rows and items of a HTML table with ease and print the results.

Scrape entire HTML tables or divs
Scrape entire HTML tables or divs

Scraping a news headline

Is scraping a news headline hard? Not in the least. In just 6 lines of code learn how to scrape that headline right into your script.

Scrape any HTML element - like News Headlines in just a couple of lines of code
Scrape any HTML element – like News Headlines in just a couple of lines of code

Filling online forms

Forms, buttons, drop-downs – all these require often actual user input. It is often not so easy to use HTTP calls (GET or POST) to submit a form and interact with a web page. The examples shows how you can leverage simulated user interaction to input a value into a web form, hit submit and recover the results.

Simulate Web Browser interaction to fill out forms or crawl websites
Simulate Web Browser interaction to fill out forms or crawl websites

Check page status

404Are you a Page Web master looking to make sure your webpage is up? Or maybe you are a SEO expert looking to find broken links (404)? The kit includes a simple example of how to check that web page status together with an entire list of HTTP status codes and descriptions.

Looking for broken links? Finding that 404 is easy with the Web Scraping Kit
Looking for broken links? Finding that 404 is easy with the Web Scraping Kit

HTTP GET or POST?

form postNot all pages/API calls submit parameters via GET (the URL), especially since you don’t face similar limits when using HTTP POST. This will show you the importance of learning how to encode and decode string params.

Who will find it useful?

vba studentBeginner Web Scrapers will find simple Web Scraping examples that are reusable and well adaptable to most web scraping scenarios – like scraping data of Wikis, Blogs and other static websites, as well as filling forms via user interaction simulation. VBA is available via Excel/Access in all office workstations without any installation consent needed from IT, this makes the kit useful as it requires no installation.

vba proAdvanced Web Scrapers will certainly appreciate a well prepared collection of various tested VBA web scraping tools. No more waiting on Internet Explorer’s the non-reliable IE “is busy” property – simply wait until a control is available on the webpage with a defined timeout. Why not use XPath or Regex to scrape those elements instead of looping through elements one-by-one. Whether you are a practiced SEO, Web Master or Web Scraper, you will definitely find this kit useful.

The VBA Web Scraping consists of an Excel file with VBA scripts. The Kit supports ONLY Windows environments

Download the VBA Web Scraping Kit

To receive the download link, proceed to payment by clicking on the Buy Now button below. Thank you in advance for purchasing the Kit and supporting new exciting posts and tools from AnalystCave!

Having issues with purchasing/downloading the kit? Write directly to me at analystcave(at)gmail.com!