|about 1 month ago||6 days ago|
|MIT License||GNU General Public License v3.0 only|
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
How long have you been using VBA? What do you use it for at your job? Or for personal reasons
3 projects | /r/vba | 16 Jun 2023
Sometimes, though more of a library / tool developer here. See stdVBA or stdVBA-examples
Bulk Structured Spreadsheet Extractor
2 projects | /r/vba | 29 May 2023
Otherwise this library poses as an example of how to use stdVBA libraries. Libraries used in this project: stdEnumerator, stdArray, stdCallback, stdCOM, stdICallable, stdLambda, stdRegex.
A Fast and Simple Settings Management Module. Automatically sets everything up and works for PC or MAC
3 projects | /r/vba | 15 Apr 2023
If you want a solution though see stdSettings. There are both system and user settings. Users are bound by their domain, so should work across organisations :)
Creating a bot for automation.
2 projects | /r/vba | 5 Feb 2023
Worst and best of VBA
2 projects | /r/vba | 6 May 2022
Aha motivations for stdVBA which is a library I made. It resolves some of these points in some ways. E.G. stdLambda acts as a Lambda syntax for VBA. stdCallback allows you to ripe the benefits of first class functions, without those functions existing.
VBA like a proper dev?
7 projects | /r/vba | 5 May 2022
my own stdVBA and some examples at stdVBA-UI
I created a fluent unit testing framework in VBA
4 projects | /r/vba | 4 Apr 2022
There're numerous unit testors out there already. I do find it interesting as to why many prefer this result.equalTo(3) compared to result = 3. My own is a single class and goes down the Test.Assert message, x=y route. As a result most of my tests look like:
VBA And The WebDriver Dilemma
2 projects | /r/vba | 18 Mar 2022
For sharepoint you need to use SOAP. I've got a small example here
Evaluating expressions from strings in VBA
4 projects | /r/vba | 20 Feb 2022
At that point, I decided to try the fabulous stdLambda tool, developed by u/sancarn. I found that stdLambda correctly evaluated all the corner cases that made Volpi's class fail. This fact excited me, so I decided to measure the time it took to evaluate an expression with variables, noticing that the u/sancarn library was quite efficient. At that point, I started to measure the performance by evaluating functions like sin, cos, tan, abs, the results seemed strange to me when I noticed that the performance was almost 50 times lower when compared to the results obtained when measuring the performance by evaluating expressions without calls to built-in functions.4 projects | /r/vba | 20 Feb 2022
Here the explanation by the library owner:
Welche Marke/Firma hat euch als Kunde verloren und warum?
2 projects | /r/FragReddit | 27 Mar 2023
What’s the best IDE?
4 projects | /r/ProgrammerHumor | 4 Mar 2023
But, with the RubberduckVBA plugin, the editor certainly becomes very usable.
Code Review - Is this clean code?
2 projects | /r/vba | 9 Feb 2023
I agree - it generally looks pretty clean in general. Do you use Rubberduck? If not, I'd run the Code Inspections - it will always find some best practices that you missed and you can tweak the output to your preference.
I’m making a vbaProject.bin packager in python and looking for anyone with opinions!
4 projects | /r/vba | 20 Jan 2023
I suppose this is like the opposite of this project: https://rubberduckvba.com
Open source projects looking for contributors
2 projects | /r/dotnet | 10 Nov 2022
This project is extending the VB6 IDE?
Eve Online fans cheer Microsoft Excel features at annual Fanfest
4 projects | news.ycombinator.com | 10 May 2022
A lot of Runescape resource to XP / hours calculators. What they really need to do is replace VBA with a proper programming interface. Rubberduck VBA  Adds some essential features into the VBA IDE but they really just need to add C# support directly.
Certainly not me
Also if you are doing VBA go and take a look at https://rubberduckvba.com/
If anyone out there is unfortunate to have to be working with VBA in the VBE, please check out https://rubberduckvba.com/
I forgot. If you work with VBA look at this https://rubberduckvba.com/ It basically replaces the VBA dev environment with something that in many ways is better than VS Code.
[EXCEL] SQLite C/ADO VBA library with reflection
3 projects | /r/vba | 13 Dec 2021
The SQLiteC subpackage uses custom compiled x32 and x64 SQLite binaries for Windows, with all extensions, including ICU, enabled (included in the repository). The SQLiteODBC driver is the other dependency (its bitness must match that of the used Excel version, and it must be installed on the target machine) used by the SQLiteADO subpackage. This project unit testing relies on the RubberDuck VBA framework. Because of early bindings, this add-in must also be installed (it does not require admin privileges).
What are some alternatives?
ECPTextStream - ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
leetcode-excel - Solutions to leetcode problems, written in the Microsoft Excel programming language (TM)
VBAChromeDevProtocol - VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium
EvilClippy - A cross-platform assistant for creating malicious MS Office documents. Can hide VBA macros, stomp VBA code (via P-Code) and confuse macro analysis tools. Runs on Linux, OSX and Windows.
VBA-CSV-interface - The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
PhotoDemon - A free portable photo editor focused on pro-grade features, high performance, and maximum usability.
RegExr - RegExr is a HTML/JS based tool for creating, testing, and learning about Regular Expressions.
Elasticsearch .NET - This strongly-typed, client library enables working with Elasticsearch. It is the official client maintained and supported by Elastic.
VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
VBA-ExtendedDictionary - Dictionary object that extends the Scripting.Dictionary
SQLiteForExcel - A lightweight wrapper to give access to the SQLite3 library from VBA.