stdVBA
VBA-Expressions
Our great sponsors
stdVBA | VBA-Expressions | |
---|---|---|
67 | 5 | |
252 | 18 | |
- | - | |
8.5 | 7.0 | |
19 days ago | 6 days ago | |
VBA | VBA | |
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
-
Why do people still use VBA?
I do RPA from VBA personally using IAccessiblity. See stdAcc (https://github.com/sancarn/stdVBA/blob/master/src/stdAcc.cls) and an example (https://github.com/sancarn/stdVBA-examples/tree/main/Example...)
-
Writing a Compiler is Surprisingly Easy (part 1)
You could have just treated everything as variant correct? That's what we do here: https://github.com/sancarn/stdVBA/blob/master/src/stdLambda....
-
Is the era of the self-taught dev over?
The responses I got was a mix. Some businesses didn't take me seriously because the main language I used was VBA. Some businesses claimed I was too eager and I "didn't have a life". No one seemed to care about the achievements I had made in the languages, like building a DSL in VBA, or this electron app. I did eventually get a job in another engineering firm though, where I spend 90% of my time to this day programming.
-
Best Practice in Aggregating Data
Really depends what you actually want to do and how neat (or fast) you want your code to be too... I typically use stdEnumerator and stdLambda from stdVBA.
-
How long have you been using VBA? What do you use it for at your job? Or for personal reasons
Sometimes, though more of a library / tool developer here. See stdVBA or stdVBA-examples
-
Why does VBA give general statement for errors and not exact?
That said it is effort. After building stdLambda which brings lambda syntax to VBA, I can tell you that error handling in this class is still trash. It's just a lot of effort to write good error messages, and handle all errors correctly. Still definitely an item on the TODO list, but will it ever be a priority? idk
-
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 :)
-
[EXCEL] How do I get the accName of a control via AccessibleObjectFromWindow
Use stdVBA's stdAcc:
-
/r/VBA PSA: ChatGPT is incredibly good at writing basic VBA code if you give it clear instructions of what you want it to do and how
Explaining code in such a way that it codes the correct thing is pretty awful though... Let's try to do that for stdTimer.
VBA-Expressions
-
Evaluate piecewise functions in VBA
So, if a Dominican needs to calculate the taxes that will be charged to them monthly, they should take pencil and paper, compute the annual amount of income and apply the corresponding formula, or they can use the following code in conjunction with VBA Expressions and get their result in a simple way.
-
Solving systems of linear equations with VBA
Systems of linear equations have been taught since high school, they are of utmost importance in mathematics. Although Excel is possible to solve, manually, equations using matrix inverse and matrix multiplication. Today we will show you a practical way to solve such problems using VBA Expressions.
-
Expression evaluator for VBA
Here is a direct GitHub link to VBA Expressions Best regards!
-
Advanced CSV filtering through VBA
After this publication, which details the reason why VBA Expressions turned out to be the most feasible option to solve the problem of integrating an expression evaluator with CSV Interface, it is time to address the process of integrating the evaluation capabilities and the ease with which this goal was achieved.
-
Evaluating expressions from strings in VBA
After a long search for something similar to the above, I decided to experiment and test the veracity of a warning that read: "... rather, it evaluates the infix expression directly. This approach is slightly more complicated than the traditional one". Then, I chose to develop an evaluator with its own grammar and a different approach to handle mathematical expressions. The solution I came up with is so called VBA Expressions. With VBA Expressions we can evaluate a variety of mathematical expressions, being able to work with arrays defined by text strings as in Java. A notorious feature is the ability to work with variables (Pi.e * 5.2Pie.1 + 3.1Pie), constants (3pi+ln(2e)), floating point numbers ((1.434E3+1000)*2/3.235E-5) and Boolean values (x>0 & Sqr(x-Ln(2))>=3 | tan(x)<0).
What are some alternatives?
ECPTextStream - ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
crypto_vba - An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
VBAChromeDevProtocol - VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium
VBA-CSV-interface - The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
Rubberduck - Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).
Code-Finds-Determinant-of-a-Array-in-C
Tiger - C++ Matrix -- High performance and accurate (e.g. edge cases) matrix math library with expression template arithmetic operators
VBCorLib - The VBCorLib framework brings many of the powerful .NET classes to VB6.
VBA-Project-Information - VBA Project Information
VBA-SQL-Library - Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.
VBA-Unit-Tester