Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
- vba-excel
- sql
- library
47,133 repositories indexed
1–8 of 8 · Most stars
Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
A powerful library extending VBA with over 100 functions for math, stats, finance, and data manipulation. It supports matrix operations, and user-defined functions, enhancing automation and analysis within Microsoft Office and LibreOffice environments for data management, financial calculations, an more.
A pure-VBA class that reads, inspects, and exports VBA source code directly from Office binary files
🎉 A very easy way to add event listeners to a userform.
Interact with the component parts of an Excel file
Object-Based mathematical operations in VBA
A method of handling mouse-related events (the MouseWheel) by leveraging the MS InkCollector
This is a class module in beta state to implement computations with large integers and reals/rationals numbers, while proposing representation of numerical values as scientific notation, allowing to obtain several cohorts for the same number (a lot of fun!).