Excel Tools

VBA Time Saver Kit

The VBA Time Saver Kit is a bundle of code modules designed to help you in your every day VBA tasks. Including code modules for Performance, Regex, Timers, Strings and more!

VBA Web Scraping Kit

The VBA Web Scraping Kit is the ideal kit for beginner and the more advanced Web Scrapers who prefer Excel/VBA as the go to tool for their Web Scraping jobs. Complete with several out of the box examples for popular use cases.

VBA Code Library

I recently came across a useful toolkit for Excel VBA: AutoMacro is an add-in for the VBA Editor, produced by the team at AutomateExcel.com. It contains an assortment of tools and features for experienced users. However it’s also the only tool I’ve seen that makes coding substantially easier for beginners, while also teaching beginners how to code in VBA. I’ll show you what I mean below.

VBA Multithreading Tool

Thought VBA multithreading was not possible? Think again, as the VBA Multithreading Tool can let you mulithread almost any VBA macro to utilize those additional cores!

Excel Scrape HTML AddIn

The Excel Scrape HTML AddIn is an advanced Add-In which allows you to easily scrape HTML content from almost any web page without needing to write a single line of VBA code.

Excel SQL AddIn

Use the Excel SQL Add-In to easily create MS Queries (SQL) directly in Excel. Excel natively supports SQL queries and the AddIn simply facilitates the process of creating them. Download data from external files or databases, merge worksheets and so much more!

Excel Google Charts Tool

Tired of boring old Excel charts. The Excel Google Charts Tool is the right tool for you. A workbook with embedded live interactive examples of Googles Charts based on Excel data.