Top 13 VBA Vba Projects
An Excel/VBA project to communicate with various cryptocurrency exchanges APIsProject mention: VBA API call with nested JSON data | reddit.com/r/vba | 2021-12-10
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
Backus-Naur Form JSON Parser based on RegEx for VBAProject 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
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.
An array class for VBA providing features found in more modern languagesProject mention: Filling combobox and sorting it | reddit.com/r/vba | 2021-08-25
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.
QR Code generator library in VBAProject mention: is there way create free qr code in excel? | reddit.com/r/excel | 2021-04-07
This project offers a powerful set of tools for work with QR codes. I test it and found it very useful.
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.Project mention: Good Projects | reddit.com/r/vba | 2021-12-23
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
Fast and convenient CSV reading and writing for VBA and Excel spreadsheets.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 tasks, Gantt chart and resources from MS Project to MS Excel. No additional software or installation required. Using build-in MS Project features (VBA).Project mention: Export from MS Project to MS Excel | reddit.com/r/projectmanagement | 2021-08-27
If needed, you may use: https://github.com/PopovGP/Export-MS-Project-to-MS-Excel
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.
Dictionary object that extends the Scripting.DictionaryProject mention: [EXCEL] Loop theory | reddit.com/r/vba | 2021-12-30
ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.Project mention: VBA CSV Interface v3 Pre-release | reddit.com/r/vba | 2021-03-01
Parse CSV/TSV through streams with the ECPTextStream class module.
A geographic toolkit/library for VBA, excel etc.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.
Tools for working with Unicode in the VB EditorProject mention: [VBE][PowerPoint] Tools for working with Unicode in VBA | reddit.com/r/vba | 2021-05-15
SQLite library for VBA wrapping ADODB and SQLite C-language API.Project mention: [EXCEL] SQLite C/ADO VBA library with reflection | reddit.com/r/vba | 2021-12-13
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).
VBA macro to print formulas with variable namesProject mention: Good general Mechanic Calculation Suite? | reddit.com/r/engineering | 2021-06-09
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
[EXCEL] Loop theory
1 project | reddit.com/r/vba | 30 Dec 2021
Accounting software glitch leads to using old/incorrect fx rates in invoices
1 project | reddit.com/r/UKPersonalFinance | 20 Dec 2021
Where should I store API Keys?
1 project | reddit.com/r/vba | 9 Dec 2021
General Git repo with vba code
2 projects | reddit.com/r/vba | 15 Sep 2021
Filling combobox and sorting it
1 project | reddit.com/r/vba | 25 Aug 2021
excel - pasting from dictionary into sheet1
1 project | reddit.com/r/vba | 14 Aug 2021
Extract data from a blob of text
1 project | reddit.com/r/excel | 12 Aug 2021
What are some of the best open-source Vba projects in VBA? This list will help you:
Are you hiring? Post a new remote job listing for free.