Top 11 VBA Vba Projects
-
Project mention: Self made Excel/VBA triggers virus scan - what to do? | reddit.com/r/vba | 2021-03-19
I've built an open source VBA-Excel library to communicate with cryptocurrency exchanges ( https://github.com/krijnsent/crypto_vba ) and have my code available as .bas and in an .xlsm file. A couple of days ago someone posted an issue that my xlsm file triggered a Windows defender alert. At my pc this doesn't happen, the AVG virus scanner also won't show anything.
-
Have you tried VBA JSON Parser?
-
Scout APM
Scout APM: A developer's best friend. Try free for 14-days. Scout APM uses tracing logic that ties bottlenecks to source code so you know the exact line of code causing performance issues and can get back to building a great product faster.
-
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 RFC-4180 compliant and unix style CSV parser library for VBA.
Use VBA CSV interface. The DumToSheet method can do the work. Here an example:
-
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
-
Using u/chunkyasparagus' example values, I populated my cExtendedDictionary and dumped it to the sheet. Took at a guess, nearly a second to run.
-
-
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: [VBE][PowerPoint] Tools for working with Unicode in VBA | reddit.com/r/vba | 2021-05-15
-
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.
-
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
- General Git repo with vba code
- Filling combobox and sorting it
- excel - pasting from dictionary into sheet1
- Extract data from a blob of text
- Best way to query a set of data in vba?
- Can I Create a Heat Map with Excel Data for a Downtown Area?
- [EXCEL] Checking one data table for information relative to another one using VBA
Index
What are some of the best open-source Vba projects in VBA? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | crypto_vba | 133 |
| 2 | VBA-JSON-parser | 66 |
| 3 | VBA-Better-Array | 54 |
| 4 | QRCodeLibVBA | 39 |
| 5 | VBA-CSV-interface | 21 |
| 6 | Export-MS-Project-to-MS-Excel | 9 |
| 7 | VBA-ExtendedDictionary | 6 |
| 8 | ECPTextStream | 4 |
| 9 | VBAUnicodeTools | 3 |
| 10 | geo_vba | 2 |
| 11 | excel-formula-print | 0 |
Are you hiring? Post a new remote job listing for free.
