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.
The Excel Optimizer is a simple, but powerful AddIn to find quick wins in identifying reasons for why your Excel workbook might be working so slow.