VBA development tools and libraries
For a programming language for automating Excel tasks, the strongest matches are vba-tools/vba-dictionary (This VBA library provides a cross-platform Scripting), vba-tools/vba-json (vba-json is a lightweight JSON parsing and conversion library) and rubberduck-vba/rubberduck (Rubberduck is a COM add-in that brings modern development). Each is ranked by relevance to your query, popularity and recent activity.
We curate open-source GitHub repositories matching “vba”. Results are ranked by relevance to your query — pick filters below to narrow, or refine with AI.
Results for “a programming language for automating Excel tasks”
Find the best repos with AI.We'll search the best matching repositories with AI.
- vba-tools/vba-dictionary
VBA-tools/VBA-Dictionary
VBA-Dictionary is a drop-in replacement for the useful and powerful Scripting.Dictionary so that it can be used with both Mac and Windows. It is designed to be a precise replacement to Scripting.Dictionary including Item as the default property (Dict("A") = Dict.Item("A")), matching error codes,…
This VBA library provides a cross-platform Scripting.Dictionary replacement, which is a useful building block for VBA development, but it does not include the IDE add-in, unit testing framework, or code generation features you're looking for.
VBAData Structures - vba-tools/vba-json
VBA-tools/VBA-JSON
2,117View on GitHubVBA-JSON is a library designed for parsing and serializing JSON data within Visual Basic for Applications environments. It functions as an office automation data library, enabling legacy Microsoft Office applications to process structured data and interact with modern web services. The tool converts raw JSON text into native objects and collections, allowing developers to access and manipulate data using standard indexing and iteration methods. It also performs the reverse operation, transforming native language structures into JSON-compliant strings for exchange with external systems. By ha
vba-json is a lightweight JSON parsing and conversion library for VBA, fitting the search for VBA development tools, though it is narrowly focused on a single data-format utility rather than providing the broader IDE add-in, testing, or refactoring features listed.
Visual BasicJSON ParsersJSON ParsingJSON Parsing - rubberduck-vba/rubberduck
rubberduck-vba/Rubberduck
2,122View on GitHubRubberduck is a development environment extension designed for legacy Visual Basic and Visual Basic for Applications projects. It functions as a comprehensive suite that integrates directly into the host editor to provide static code analysis, automated refactoring, and project management capabilities. The tool distinguishes itself by implementing a formal grammar-based parsing engine that transforms source code into a structured abstract syntax tree. This allows for deep static analysis, enabling the identification of defects and style inconsistencies. It further supports development workflo
Rubberduck is a COM add-in that brings modern development tooling directly into the VBA IDE, with static analysis, refactoring, and unit testing support — fitting your need for an integrated VBA development environment.
C#Unit Testing FrameworksCode Refactoring Tools
