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). closedxml/closedxml and prabirshrestha/vim-lsp round out the shortlist. 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 - closedxml/closedxml
ClosedXML/ClosedXML
5,630View on GitHubClosedXML is an open-source .NET spreadsheet library and wrapper used for reading and writing Excel files. It provides an object-oriented interface for manipulating workbook structures and cell data within .xlsx and .xlsm files using the OpenXML standard. The library abstracts the complexity of the OpenXML SDK, allowing developers to generate and modify spreadsheets programmatically without requiring Microsoft Office to be installed on the system. It covers a range of spreadsheet management capabilities, including workbook generation, file loading, and data extraction. The toolset supports p
ClosedXML is a .NET library for programmatically reading and writing Excel files, which supports Office automation but does not provide any VBA development tools, IDE add-ins, code analysis, refactoring, or testing frameworks.
C#Excel AutomationExcel File Parsers - prabirshrestha/vim-lsp
prabirshrestha/vim-lsp
3,368View on GitHubvim-lsp is a Vim plugin that implements the Language Server Protocol to provide an asynchronous code intelligence tool for the editor. It serves as a bridge between Vim and external language servers, providing semantic code analysis and IDE-like navigation and diagnostics. The project provides a refactoring interface for renaming symbols across a workspace and applying quick-fixes. It also enables semantic highlighting, which color-codes elements based on their meaning as determined by the language server. The plugin covers a broad surface of capabilities, including symbol navigation and dis
This is a generic Vim plugin for Language Server Protocol integration, not a VBA-specific tool; it could support VBA development only if a VBA language server is configured, but it lacks any built-in Excel integration, VBA code analysis, or Office automation features the search asks for.
Vim ScriptCode Refactoring ToolsStatic Code Analysis - xlwings/xlwings
xlwings/xlwings
3,312View on GitHubxlwings - Make Excel fly with Python!
xlwings integrates Python with Excel to automate tasks, but it's not a VBA development tool—it replaces VBA with Python rather than aiding in writing or testing VBA code, so it doesn't fit the requested category.
PythonExcel AutomationExcel Parsers - jmcnamara/xlsxwriter
jmcnamara/XlsxWriter
3,911View on GitHubXlsxWriter is a library for generating spreadsheets in the XLSX format, functioning as an Excel workbook writer and file generator. It provides the capability to write data, apply cell formatting, and build complex layouts across multiple worksheets. The project distinguishes itself with a memory-optimized writing mode that flushes large datasets to disk row-by-row, enabling the creation of files exceeding 4 GB while minimizing RAM consumption. It also includes a specialized mechanism for embedding binary project files and digital signatures to enable VBA macros and signed scripts within work
XlsxWriter is a Python library for generating Excel spreadsheets and can include VBA macros, but it is a file-creation tool, not a VBA development environment or automation library for writing and debugging VBA code within Office.
PythonExcel AutomationVBA Macro Embedding
