VBA Web Scraping Kit – easy scraping for Excel

1 Star2 Stars3 Stars4 Stars5 Stars (17 votes, average: 4.06 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!

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

Trouble-shooting

The VBA Web Scraping Kit leverages Microsoft Internet Explorer built-in components. Hence, in case of issues e.g. “Access Denied” VBA error please first make sure your Internet Explorer settings are configured correctly:
Internet Options -> Security Tab > Custom Security Level -> Miscellaneous -> Access Data Sources Across Domains -> Enable

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 Excel SQL AddIn and supporting new exciting posts and tools from AnalystCave!

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

VBA Time Saver Kit – largest collection of VBA Code Snippets

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

VBA Time Saver KitThe VBA Time Saver Kit is a need-to-have kit for beginner and advanced VBA coders. It makes your life easier as a VBA developer and makes it the first place to go for VBA code snippets and examples.

Ever got stuck trying to remind yourself what was the name of that VBA function? Googling again for a commonly used VBA code snippet? Struggling to remember the syntax of the Do Until loop or Select Case conditional statements? The VBA Time Saver Kit is just what most VBA beginner and advanced developers needs.

vba code snippetsA rich collection of ready VBA Code Snippets – each with a ready-to-run example
vba functions referenceA VBA Reference of 50 links to VBA native functions sorted into 4 basic categories: Conversion, Date, File and String Functions. Basic examples of creating loops, conditional statements and a list of basic VBA Data Types

VBA Code Module Snippets

VBA Code ModulesThe VBA Timer Saver is a collection of code snippets / assets that have been built over time on AnalystCave.com. VBA Code Snippets have been groups into over 11 unique Code Modules with Code Snippets you use on a Daily Basis when programming in Excel VBA.

Code Modules have been separated to allow you to import them (*.bas files) to your project at ease on demand whenever you are struggling with a particular tasks e.g. Reading/Writing to Files, wanting to present Macro execution progress via a Progress Bar and much more.

Click on the images below to learn more what is contained in VBA Timer Saver package:

Who will find it useful?

The VBA Time Saver Kit is dedicated equally to VBA Beginners (easy VBA Function reference, code examples) as well as Advanced VBA Coders (ready useful code snippets).

vba studentVBA Beginners will find the VBA Time Saver Kit especially useful when trying to reference available VBA Functions. The Kit groups most available VBA Functions into 4 categories: Dates, Strings, Files and Conversions – all linking out to function definitions here at AnalystCave. It contains ready easy to reference examples of VBA Loops and Conditional statements.

vba proAdvanced VBA codes will appreciate the collection of VBA time saving code modules, often complex functions that prove useful during mundane coding tasks. Cool examples include an advanced progress bar (userform), functions for measuring code execution (up to milliseconds), creating arrays from strings and even a function allowing you to create an additional VBA thread!

Installation Notes

Be aware the VBA Time Saver contains a variety of VBA Code Snippets, some of which may not work on Mac OS due to a lack of system libraries to support these features.

Be aware some Antivirus (at least Avast, ClamAV and Rising) software may incorrectly assess that the Kit contains a Virus. This is not the case. If you get a notification like this please reach out to me directly at analystcave(at)gmail.com to receive the Kit in another format.

Download the VBA Time Saver Kit

To receive a one-time download link to the provided email, 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!

Have questions or issues with purchasing/downloading the AddIn? Write directly to me at analystcave(at)gmail.com!

VBA Compiler Startup Kit

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

The VBA Compiler Startup Kit is a optional purchase for the free VBA Compiler AddIn. The AddIn itself allows you to compile VBA (if compatible) code to a VB.NET COM visible DLL that can be used/executed directly from VBA.

BEFORE PURCHASING The VBA Compiler Startup Kit BE SURE TO INSTALL AND CHECK IF The VBA Compiler AddIn WORKS FOR YOU FIRST!

DOWNLOAD

What it contains

The VBA Compiler Startup Kit is a set of code examples to start you off with using the VBA Compiler.
VBA Compiler Startup Kit

It contains a rich mix of code examples which exhibit some common issues as well as usable/compilable code examples that can well aid you in using the VBA Compiler. You can achieve many powerful things with the VBA Compiler that you will specifically learn by using this kit. My personal favorite example is For Loop multithreading which isn’t achievable in native VBA – allow you to squeeze awesome performance from your compiled code.

What code examples will you find?

Currently the VBA Compiler Startup Kit contains the following code examples:

Code example Description
Hello World Simple string concatenation function
Typical VBA practices that won’t compile to VB.NET Some typical compilation issues you may run into and how to fix them
Edit Excel Edit your running Excel Workbook directly from your VB.NET DLL. Set a Range or Cell value
Passing arrays as arguments How to pass arrays to your VB.NET Subs and Functions
Sharing Classes and other objects Sharing VBA Classes and other objects with your VB.NET DLLs
Returning multiple results from VB.NET How to return multiple results from VB.NET by passing them by ref
MessageBoxes and InputBoxes How to use MsgBoxes and InputBoxes?
Quick Sort Comparing QuickSort algorithms on a VBA Array of Long variables (VBA vs. VB.NET)
Hacking VBA – Multithreading How to hack your VBA code to enable VB.NET parallel multithreading of VBA loops

Buy it and support the project!

By buying the VBA Compiler Startup Kit you are supporting the development of this Add-In.

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