stdEnumerator - Enumerate and manipulate any collection/array/class with very few statements

This page summarizes the projects mentioned and recommended in the original post on /r/vba
#vba-excel #SQL #Library

Our great sponsors
  • Mergify - Updating dependencies is time-consuming.
  • SonarLint - Clean code begins in your IDE with SonarLint
  • InfluxDB - Collect and Analyze Billions of Data Points in Real Time
Our great sponsors

  • stdVBA

    VBA Standard Library - A Collection of libraries to form a common standard layer for modern VBA applications.

    It's nothing too fancy but it is present in stdVBA repository named testBuilder.xlsm. Unfortunately I can't use rubberduck at work, so I prefer to avoid its usage altogether, which is also the reason for several other style choices.

  • VBA-SQL-Library

    Object-based Database Interaction for VBA. Create SQL Statements with VBA objects instead of string concatination.

    VBA-SQL-Library/SQLUnitTests.bas at master · Beakerboy/VBA-SQL-Library (github.com)

  • Mergify

    Updating dependencies is time-consuming.. Solutions like Dependabot or Renovate update but don't merge dependencies. You need to do it manually while it could be fully automated! Add a Merge Queue to your workflow and stop caring about PR management & merging. Try Mergify for free.

  • VBA-STD-Builder

    A temporary project for building a VBA code builder, to allow people to work in VSCode and perform Live Tests

    Template can be found here. Sadly this doesn't deal with compile errors, and it really isn't a nice user experience, but it works.

  • VBAPackager

    Based on Evil Clippy, designed to package VBA documents (WIP)

    Long term, I have 2 projects VBA-Packager which attempts to do text->xlsm source injection, and VBA-Compiler which attempts to do vba-like --> vba compilation. The latter project of which is likely to be deprecated in a new project in the future. We'll see :)

  • stdVBA-Compiler

    VBA-like source to VBA source code compiler

    Long term, I have 2 projects VBA-Packager which attempts to do text->xlsm source injection, and VBA-Compiler which attempts to do vba-like --> vba compilation. The latter project of which is likely to be deprecated in a new project in the future. We'll see :)

  • Choropleth-Map-of-Myanmar

    A Choropleth Map of Myanmar in Excel using VBA

    Hi, sancarn, just greeting! We talked about your VBA shape Events class some time ago, I was working on a shape map project back then. I hope you will probably remember me once you see the image of the map. Still haven't finished it yet as I was side-tracked to another project which walks through VBA project code modules.

  • VBA-Project-Information

    VBA Project Information

    Hi, sancarn, just greeting! We talked about your VBA shape Events class some time ago, I was working on a shape map project back then. I hope you will probably remember me once you see the image of the map. Still haven't finished it yet as I was side-tracked to another project which walks through VBA project code modules.

  • SonarLint

    Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.

  • VBA-Unit-Tester

    I just threw together a quick example of my testing system here: https://github.com/Beakerboy/VBA-Unit-Tester

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts