Fluent-VBA
VBA
Fluent-VBA | VBA | |
---|---|---|
3 | 1 | |
5 | 407 | |
- | - | |
8.5 | 0.0 | |
4 days ago | about 1 year ago | |
VBA | VBA | |
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.
Fluent-VBA
-
What are your biggest VBA projects?
As a personal project, I created a fluent unit testing framework in VBA. The project uses 18 class modules: 12 classes and 6 interfaces. It uses the OOP concepts in VBA (encapsulation, polymorphism, and composition) heavily. It incorporates +150 tests including a number of tests to test itself. There are +3k loc in total. And the project took around a year to put together on and off.
-
I created a fluent unit testing framework in VBA
You can check out my mTests.bas module to see the set of tests that I use to test the framework. These tests are located in the runMainTests sub. this sub runs three other subs: metaTests, positiveDocumentionTests and negativeDocumentationTests. metaTests are what the framework uses to tests iteself. Positive tests check that the API should return true when it should. And negative tests check that the API should not return false when it shouldn't. In addition to that, I have six example subs showing the different types of ways tests can be written.
VBA
-
How easy is it to switch industries?
Lots of stock/option trading stuff. Detailed web scrapers. Couple games. Some bioinformatic algorithms. I don’t have em on my website but I automated all the web pages in vba (which is why it isn’t a great website but I’m also not a website developer). So my site and GitHub are good ways to get sample code out there.
What are some alternatives?
vba-test - Add testing and TDD to VBA on Windows and Mac
Excel-Pomodoro-Timer - Excel Pomodoro Timer
stdVBA - VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.
JustMoreVBA - A collection of code snippets, modules, and classes that I've written and collected over the years.
Battleship - An Object-Oriented VBA experiment
add-chatgpt-to-microsoft-word - How to add ChatGPT's Text Completion to Microsoft Word
crypto_vba - An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
vba-macros - Some VBA macros for personal use
msaccess-vcs-addin - Synchronize your Access Forms, Macros, Modules, Queries, Reports, and more with a version control system.
Speed-Bionic-Reading - Speed reading technique that has recaptured public interest due to Bionic Reading done in a VBA Macro
integrate-palm-into-word - How to use Google's PaLM 2 language model in Microsoft Word.
VBAIPFunctions - IP manipulation and lookup VBA functions