How to put Excel VBA into git

Question

I've inherited some VBA in Excel and want to put it into git. As it stands, git sees it as binary and doesn't want to do file change deltas but duplicate the whole file.

I want to break the individual macros out into files to put them into git. Is there a standard way to do this?

Answer 1

If you use Rubberduck VBA, after clicking

You can use the file menu to "Export Active Project", which exports the form binaries and the code as BAS objects, which are just plain text. Then you can commit to git.

Answer 2

You should be able to export modules as text to a git folder then commit as follows.

In The VBA Editor Add modules for each macro (Menu Insert/Module) copy each macros code into a module and save as a text file with control + E. Save into your git folder and use the normal git procedures to commit any changes.

When you change the vba code re save (control+E) the module and update git as normal.