VBA Utility Library — 9 Reusable Modules

The nine modules

• File I/O: robust open, save, and path resolution with network-drive handling
• Range utilities: fast array-based read and write that avoids cell-by-cell bottlenecks
• Logging: structured log output to a sheet or file with severity levels
• Fuzzy comparison: string similarity scoring with multiple algorithm options
• Outlook dispatch: templated email send with attachment management
• Progress UI: non-blocking progress bar with cancel support
• Config parsing: read settings from a config sheet with type coercion
• Error wrappers: consistent On Error handling that logs and continues
• Collection helpers: dictionary, ordered map, and set operations on top of Scripting.Dictionary

Self-contained by design

Every module has zero external references beyond VBA built-ins and Scripting.Runtime. Drop in, set a reference, ship. No DLLs. No add-ins. No deployment surprises when the file lands on another machine.

Why it exists

This is a developer tool. It exists so that building a new automation tool takes a day instead of a week. Every function in the library was extracted from a production project where it had to work on real data under real constraints.

Full documentation (click to expand)

The user manual covers: module-by-module API reference, import patterns, the config sheet format, the log format, and the Outlook dispatch template syntax. Includes sample code for each module.

Read it here: LIB User Manual.

Related services

The library underpins every tool in the tools catalog. For custom development work built on top of it see the Excel VBA development service.