stdVBA Alternatives
Similar projects and alternatives to stdVBA
-
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.
-
ECPTextStream
ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
-
SonarLint
Deliver Cleaner and Safer Code - Right in Your IDE of Choice!. SonarLint is a free and open source IDE extension that identifies and catches bugs and vulnerabilities as you code, directly in the IDE. Install from your favorite IDE marketplace today.
-
Rubberduck
Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).
-
VBA-SQL-Library
Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
-
-
VBAPackager
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.
-
Scout APM
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.
-
VBA-Expressions
A powerful mathematical and string expressions evaluator for VBA.
-
VBA-STD-Builder
A temporary project for building a VBA code builder, to allow people to work in VSCode and perform Live Tests
-
-
VBAChromeDevProtocol
VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium
-
VBA-Web
VBA-Web: Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web
-
-
-
-
stdVBA-Inspiration
Sample VB6 and VBA code used for inspiration of syntax/algorithms for usage in the stdVBA library
-
VBA-ExtendedDictionary
Dictionary object that extends the Scripting.Dictionary
-
-
-
stdVBA reviews and mentions
-
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.
Here the explanation by the library owner:
-
excel 365 Date Picker Problem
This is why I use stdDate 😊 Though it's not particularly fast mind-you
-
Folder Structure/Layouts for Developing Excel Reports/Applications
see an example here.
-
Good Projects
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
-
VBA grouping selection areas by column.
With stdVBA you could do something like this, I think (untested):
-
Looking for a VBA math expression evaluator
Use stdLambda...? [docs]
Stats
sancarn/stdVBA is an open source project licensed under MIT License which is an OSI approved license.
Popular Comparisons
Are you hiring? Post a new remote job listing for free.