VBASuite

---

Contents

Overview

Features

Development

VBA Modules

• modUtils: Utilities Module
• modSetup: Module housing various setup workflows
• modOptimize: VBA optimization module

Git and Excel

This repository utilizes the following resources for optimal VBA, Excel, and Git Integrations:

• Git Flow
• Git LFS
• GitHub CLI
• Git XL
• vbaDeveloper Excel AddIn
• xvba VSCode Addins

Other tools worth mentioning:

• ImportExcel PowerShell Module
• vba-blocks CLI tool

Setup

1. Download and install Git XL from the xltrail website.
2. Initialize Git XL via git xl install and then git xl install --local.
3. Initialize Git-LFS and Git-Flow on the repository, add respective .gitattributes.

Release Workflow

1. Utilize git-flow to create release/ branches off the default develop branch
2. Close release branches adding a corresponding git tag for the version number.
3. Push to remote
4. Run command gh release create <version> --generate-notes --title 'Version <version>' from terminal using GitHub-CLI.
5. This will invoke the release-xl.yml GitHub Action workflow to add the versioned workbook to the release assets.