Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression. Learn more →
stdVBA Alternatives
Similar projects and alternatives to stdVBA
-
ECPTextStream
ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
-
VBA-CSV-interface
The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
-
InfluxDB
Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.
-
VBAChromeDevProtocol
VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium
-
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.
-
-
ONLYOFFICE
ONLYOFFICE Docs — document collaboration in your environment. Powerful document editing and collaboration in your app or environment. Ultimate security, API and 30+ ready connectors, SaaS or on-premises
-
-
VBA-ExtendedDictionary
Dictionary object that extends the Scripting.Dictionary
-
-
-
VBA-Web
VBA-Web: Connect VBA, Excel, Access, and Office for Windows and Mac to web services and the web
-
-
-
-
-
-
VBA-Expressions
A powerful string expression evaluator for VBA, which puts more than 60 mathematical, financial, date-time, logic and text manipulation functions at the user's fingertips.
-
-
-
SonarQube
Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
stdVBA reviews and mentions
-
Bulk Structured Spreadsheet Extractor
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
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.
-
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
-
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:
-
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:
-
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
-
A note from our sponsor - InfluxDB
www.influxdata.com | 30 May 2023
Stats
sancarn/stdVBA is an open source project licensed under MIT License which is an OSI approved license.
The primary programming language of stdVBA is VBA.