ECP Solutions builds professional-grade VBA libraries and developer tools that bring modern programming paradigms to Microsoft Office and LibreOffice โ pure VBA, zero COM dependencies, production-ready.
The first embeddable scripting language that turns VBA into a script host. C-like syntax with first-class functions, closures, anonymous functions, for-in/for-of loops, arrays & objects with method chaining, native regex engine, try/catch, and FFI for calling existing VBA code via @(...) passthrough. Full AST-based compiler and VM โ readable, debuggable, no opaque bytecode.
Over 100 built-in functions for math, statistics, finance, geometry, and data manipulation. Supports matrix operations (LU, Cholesky, QR decomposition), curve fitting, multivariate linear regression, user-defined functions, and implied multiplication. The math engine behind ASF.
View on GitHub โA high-performance buffered text reader for VBA. Handles files up to 2 GB at speeds up to 600 MB/sec with configurable buffer sizes. Supports CRLF, LF, and CR delimiters โ essential for structured file processing like CSV parsing. No memory overloads, no external API dependencies.
View on GitHub โFull VS Code language support for ASF. Syntax highlighting, real-time diagnostics, hover documentation, and code completion โ a modern development experience for writing scripts that run inside VBA. Includes 181 ready-to-use code snippets.
View on GitHub โPure VBA from top to bottom. No external DLLs, no API references, no deployment nightmares. Copy the modules and run โ even in locked-down enterprise environments.
ASF is a complete compiler and VM โ not a hack. VBA-Expressions uses "analyze once, evaluate many" design. ECPTextStream uses buffered I/O for 600 MB/sec throughput. Engineered, not scripted.
The Table Uniformity method powering our CSV dialect detection is peer-reviewed in SAGE's Data Science journal and independently adopted in Rust and Python ecosystems.
VBA-Expressions runs on both Microsoft Office and LibreOffice. Your automation doesn't lock you into a single vendor โ even available as a LibreOffice extension.
Comprehensive test suites validate semantics and runtime behavior across arithmetic, flow control, functions, closures, and object manipulation. Not "it works on my machine" โ verified.
ASF works as a runtime library in locked Excel files โ perfect for add-ins and distributed tools. No recompilation needed, unlike alternatives that require new toolchains.
Buffered I/O ยท 600 MB/s
Math Engine ยท 100+ Functions
Scripting Language ยท VM
IDE ยท 181 Snippets
ECPTextStream handles high-performance file reading. VBA-Expressions provides the mathematical backbone โ embedded directly into ASF via the @(...) passthrough. ASF compiles and executes modern scripts on top of VBA. And asf-vscode completes the loop with a modern developer experience.
Explore the repositories, star what solves your problem, and bring modern engineering to your VBA projects.