VBAToolKit
Toolkit for quality development with Excel VBA
Install / Use
/learn @jpimbert/VBAToolKitREADME
VBAToolKit
VBAToolkit is an open-source framework aiming to ease the development of quality VBA code.
It is designed to be used as a tool on the developer's machine to create and manage a VBA project (only Excel at the moment).
Its features include :
Management of configurations
Currently, its main feature is to ease the management of different configurations of a VBA project. Mainly a configuration for delivery to the end user, and a configuration for development purpose. The second one contains test modules not included in the first one.
Allowing versioning
VBA modules are stored separately in text files, consistent versioning is made possible.
Though, VBATookit does not integrate any versioning system ; using a third party software such as Git in the project directory is the way.
Team collaborative development Excel files can be regenerated from the text source code under version management. This facilitates the merge operations and thus the team collaborative development.
Facilitating Test Driven Development
VBAToolkit integrates the open-source unit-testing VBAUnit framework to encourage and facilitate Test Driven Development, an healthy development method.
Convenient interface
A toolbar in Excel and several automatic functions provide easy access to these features.
VBAToolKit is developed by Skwal-Soft and JPI-Conseil
This work is licensed under the Apache License, version V2.0
Related Skills
node-connect
345.4kDiagnose OpenClaw node connection and pairing failures for Android, iOS, and macOS companion apps
frontend-design
104.6kCreate distinctive, production-grade frontend interfaces with high design quality. Use this skill when the user asks to build web components, pages, or applications. Generates creative, polished code that avoids generic AI aesthetics.
openai-whisper-api
345.4kTranscribe audio via OpenAI Audio Transcriptions API (Whisper).
qqbot-media
345.4kQQBot 富媒体收发能力。使用 <qqmedia> 标签,系统根据文件扩展名自动识别类型(图片/语音/视频/文件)。
