Top 11 VBA Vba Projects
An Excel/VBA project to communicate with various cryptocurrency exchanges APIsProject 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.
Backus-Naur Form JSON Parser based on RegEx for VBAProject mention: Extract data from a blob of text | reddit.com/r/excel | 2021-08-12
Have you tried VBA JSON Parser?
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.
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 RFC-4180 compliant and unix style CSV parser library for VBA.Project mention: VBA Import of CSV to Excel Sheet | reddit.com/r/excel | 2021-11-15
Use VBA CSV interface. The DumToSheet method can do the work. Here an example:
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
Dictionary object that extends the Scripting.DictionaryProject mention: excel - pasting from dictionary into sheet1 | reddit.com/r/vba | 2021-08-14
Using u/chunkyasparagus' example values, I populated my cExtendedDictionary and dumped it to the sheet. Took at a guess, nearly a second to run.
Run Linux Software Faster and Safer than Linux with Unikernels.
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.
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
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.
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
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
Best way to query a set of data in vba?
1 project | reddit.com/r/vba | 1 Aug 2021
Can I Create a Heat Map with Excel Data for a Downtown Area?
1 project | reddit.com/r/excel | 14 Jul 2021
[EXCEL] Checking one data table for information relative to another one using VBA
1 project | reddit.com/r/vba | 13 Jul 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.