VBA-JSON-parser
stdVBA
Our great sponsors
| VBA-JSON-parser | stdVBA | |
|---|---|---|
| 2 | 56 | |
| 92 | 185 | |
| - | - | |
| 0.0 | 6.0 | |
| 6 months ago | 13 days ago | |
| VBA | VBA | |
| GNU General Public License v3.0 only | MIT License |
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.
VBA-JSON-parser
We haven't tracked posts mentioning VBA-JSON-parser yet.
Tracking mentions began in Dec 2020.
stdVBA
- 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
-
Looking for a VBA math expression evaluator
Use stdLambda...? [docs]
You probably want to look through the tests if you want examples. Though the tests have explicit calls to .Run(...) and .RunEx(...).
What are some alternatives?
ECPTextStream - ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.
Export-MS-Project-to-MS-Excel - Export tasks, Gantt chart and resources from MS Project to MS Excel. No additional software or installation required. Using build-in MS Project features (VBA).
VBA-Better-Array - An array class for VBA providing features found in more modern languages
VBAChromeDevProtocol - VBA (Excel) based wrapper for Chrome Developer Protocol (CDP) - sorta a VBA version of Puppeteer/Selenium
crypto_vba - An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
Rubberduck - Every programmer needs a rubberduck. COM add-in for the VBA & VB6 IDE (VBE).
VBA-ExtendedDictionary - Dictionary object that extends the Scripting.Dictionary
VBA-CSV-interface - The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.
VBA-Unit-Tester
VBAUnicodeTools - Tools for working with Unicode in the VB Editor
wordle97 - Wordle for Word 97