Top 13 VBA Vba Projects
-
It basically uses the Dictionary object to create variables (e.g. with a dictionary in a dictionary) and after that using that library to transform it into a string. I'm using it in my project here: https://github.com/krijnsent/crypto_vba/blob/master/ModExchKucoin.bas
-
Project mention: Accounting software glitch leads to using old/incorrect fx rates in invoices | reddit.com/r/UKPersonalFinance | 2021-12-20
Downloaded and imported VBA-JSON-parser
-
Scout APM
Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.
-
u/senipah has done a lot of work extending VBA's array capabilities here. I would look into this to sort your data in memory rather than reinventing the wheel.
-
This project offers a powerful set of tools for work with QR codes. I test it and found it very useful.
-
VBA-CSV-interface
The most powerful and comprehensive CSV/TSV/DSV data management library for VBA, providing parsing/writing capabilities compliant with RFC-4180 specifications and a complete set of tools for manipulating records and fields.
If you want to do something really useful, you can contribute to one of the many amazing libraries around like stdVBA (you can see the backlog here), CSV Interface or VBCorLib
-
Project mention: A new year, a new tool to work with CSV files. Happy holidays! | reddit.com/r/vba | 2021-12-23
I tried VBA-CSV, but I guess there is some Excel/Office specific code in there.
-
Export-MS-Project-to-MS-Excel
Export tasks, Gantt chart and resources from MS Project to MS Excel. No additional software or installation required. Using build-in MS Project features (VBA).
If needed, you may use: https://github.com/PopovGP/Export-MS-Project-to-MS-Excel
-
SonarQube
Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
-
-
ECPTextStream
ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
Parse CSV/TSV through streams with the ECPTextStream class module.
-
Project mention: Can I Create a Heat Map with Excel Data for a Downtown Area? | reddit.com/r/excel | 2021-07-14
As u/Grey_Patagonia_Vest describes: you could add some more information like a postal code to the address. If you're looking for "main street", that will give tons of hits, if you add a postal code and/or city there is a higher chance you get to your desired location/city. I've built this toolkit, based on OpenStreetMap / Nominatim to transform addresses to lat/long -> https://github.com/krijnsent/geo_vba , using the geo_nom_search function, you could give it a try.
-
Project mention: [VBE][PowerPoint] Tools for working with Unicode in VBA | reddit.com/r/vba | 2021-05-15
-
Complete project source code with dependencies is available from the GitHub repo and the project documentation - from the GitHub pages site. I perform unit testing under x32/VBA6 (Excel XP/2002 SP3) and x64/VBA7 (Excel 2016) environments. With the entire repository cloned on Windows 10 and the two dependencies (the SQLiteODBC driver and the RubberDuck VBA add-in) installed, the following two quick checks can be executed right away from the immediate pane. This command ?LiteMan(":mem:").ExecADO.GetScalar("SELECT sqlite_version()") returns SQLite library version used by the SQLiteODBC driver (usually embedded), e.g., 3.23.3, and this command ?SQLiteC("").CreateConnection(":mem:").ExecADO.GetScalar("SELECT sqlite_version()") returns SQLite library version loaded by the project, e.g., 3.37.0. The project also includes a set of examples, which should also run out-of-the-box (see documentation).
-
Shameless plug, but I wrote an Excel macro that displays the formula in terms of its variables. Makes checking a breeze. And super easy to paste into Word if you are creating a report.
VBA Vba related posts
Index
What are some of the best open-source Vba projects in VBA? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | crypto_vba | 139 |
| 2 | VBA-JSON-parser | 68 |
| 3 | VBA-Better-Array | 57 |
| 4 | QRCodeLibVBA | 43 |
| 5 | VBA-CSV-interface | 24 |
| 6 | VBA-CSV | 9 |
| 7 | Export-MS-Project-to-MS-Excel | 9 |
| 8 | VBA-ExtendedDictionary | 6 |
| 9 | ECPTextStream | 4 |
| 10 | geo_vba | 4 |
| 11 | VBAUnicodeTools | 3 |
| 12 | SQLiteC-for-VBA | 1 |
| 13 | excel-formula-print | 0 |
Are you hiring? Post a new remote job listing for free.
