A collection of production-grade VBA modules for real-world systems: ETL pipelines, SQL Server integration, security tooling, and advanced automation built in Microsoft Access / VBA.
High-performance ETL pipeline that:
- Reads ODBC-linked QuickBooks data
- Builds schema-driven INSERT statements
- Streams records using parameterized ADO commands
- Executes inside a single SQL transaction with rollback protection
Location: /qb-etl
CreateQBFile
- VBA that generates QuickBooks-importable .IIF files from SQL data for batch transaction import
Location: /qb-etl
Reversible string obfuscation system with cross-language interoperability.
Location: /security
Location: /winapi
Low-level Windows helpers implemented in VBA using Win32 API calls.
Includes:
Idle Time Detection Retrieves machine-level idle time (seconds since last user input) using the Windows API. Useful for session management, inactivity monitoring, and graceful application shutdown in long-running VBA applications.
- Transaction safety
- Schema-driven logic
- Explicit error boundaries
- Portable SQL generation
- Maintainable, testable VBA
This repository demonstrates how VBA can be used to build reliable, enterprise-grade systems — not just macros.