Import and export VBA from an Excel workbook
2020.04.20 2022.03.31
Project archived on 18 November 2022
This library provides a way to export VBA code to a folder and import it back. That folder can then be version-controlled using something like git.
I created this project a while ago with the goal of facilitating version-controlling VBA code in an Excel workbook. It is a replacement to the VbaSync project one of my colleagues created.
This library is currently integrated into a larger project such that the import runs when the workbook is opened and the export runs when the workbook is saved or closed. That way the VBA code outside the workbook is kept in sync with the code inside the workbook.
It is unlikely this tool will see major updates beyond the initial version as I now very rarely work with Excel workbooks and VBA.