For those who don’t know, Excel has it’s own embedded scripting language: VBA
Excel even has it’s own embedded (ancient) code editor to write these scripts!
But if you do use them, often times you will want to get the code out of the file. Or inject new code into the file.
At a previous job we had this requirement because we were working with some Excel workbooks that had a lot of scripts that needed improvements. And we (the developers) wanted to get all this code into Git to help manage it.
So I build this library to provide a way to export VBA code to a folder and import it back. That folder can then be version-controlled using Git 🙌
This was inspired by (and later replaced) an alternative implementation a colleague made using VBA - VbaSync
We integrated this library into a larger project and hooked it up to some workbook events such that new code was imported on startup, and exported when the file is saved or closed. This kept the code inside and outside in sync.
I’ve since abandoned this project since I changed jobs no longer work with Microsoft Excel workbooks and VBA 😌
The code is still available here if you are interested!