stdVBA
Rubberduck
Our great sponsors
stdVBA | Rubberduck | |
---|---|---|
46 | 16 | |
147 | 1,627 | |
- | 1.4% | |
7.0 | 8.6 | |
27 days ago | 25 days ago | |
VBA | C# | |
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.
stdVBA
-
Find 'Keys', and count and/or change invalid referential values in a Range
Typically I use my stdEnumerator and stdLambda class for this:
-
Worst and best of VBA
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?
my own stdVBA and some examples at stdVBA-UI
-
Click a button on the ribbon
As you can see sometimes these techniques can get rather complicated, however in reality most of the complexities of this task can be hidden behind an abstraction. This is where I suggest the use of the stdVBA library. This library (created by myself) contains some simple abstractions of the IAccessible API and work in conjunction with stdLambda to help you create small utilities like the above, with very little effort:
-
I give up.
Uses stdVBA's stdAcc library, but works a charm! :D
-
Using Mail Merge and VBA to create a merge that pulls from multiple rows that have a matching cell
You'd need to download stdLambda, stdEnumerator and stdICallable and import these into your VBA library in order to work with them.
-
I created a fluent unit testing framework in VBA
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:
-
tips to improve speed - general
Yes, i created it as part of stdVBA
-
VBA And The WebDriver Dilemma
For sharepoint you need to use SOAP. I've got a small example here
-
Evaluating expressions from strings in VBA
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.
Rubberduck
- does everyone know about rubber duck? I love this little plugin
-
Eve Online fans cheer Microsoft Excel features at annual Fanfest
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 [1] 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
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).
-
Error when closing Excel, after using Rubberduck
try https://github.com/rubberduck-vba/Rubberduck/issues
-
VBA is a Poor Programming Language
Oh, and if you're going to do software engineering in VBA, you must use the open siurce Rubberduck VBA plug-in. It makes the VBE usable. https://rubberduckvba.com/
- Is there a VBA cleaner program?
-
VBA + RubberDuck Question to change names
I tried searching everywhere, aparently i needed to do a "part-parse" according to this thread: https://github.com/rubberduck-vba/Rubberduck/issues/3081 However that didnt solve anything.
What are some alternatives?
leetcode-excel - Solutions to leetcode problems, written in the Microsoft Excel programming language (TM)
ECPTextStream - ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
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, fields and files.
Elasticsearch .NET - This strongly-typed, client library enables working with Elasticsearch. It is the official client maintained and supported by Elastic.
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.
RegExr - RegExr is a HTML/JS based tool for creating, testing, and learning about Regular Expressions.
VBAChromeDevProtocol - VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium
xlrd - Please use openpyxl where you can...
Fluent Assertions - A very extensive set of extension methods that allow you to more naturally specify the expected outcome of a TDD or BDD-style unit tests. Targets .NET Framework 4.7, as well as .NET Core 2.1, .NET Core 3.0, .NET 6, .NET Standard 2.0 and 2.1. Supports the unit test frameworks MSTest2, NUnit3, XUnit2, MSpec, and NSpec3.
VBA-JSON-parser - Backus-Naur Form JSON Parser based on RegEx for VBA
Fleck - C# Websocket Implementation
PhotoDemon - A free portable photo editor focused on pro-grade features, high performance, and maximum usability.