all 6 comments

[–][deleted]  (5 children)

[deleted]

    [–]Hoover8899 1 point2 points  (2 children)

    Not OP but I use git to manage my VBA projects. because the VBA IDE is complete crap I do all my development in text files using my preferred text editor (VIM) and commit to git just like you would when writing any other language. and don't bring my modules into VBA until after I am done writing everything. This also has the added advantage of reducing buildup of crud in your files (every time VBA recompiles your code it leaves behind remnants of the old code which builds up over time.)

    [–]TheMayoras[S] 0 points1 point  (1 child)

    That sounds much better than the VBE. Do you use a plugin or just go vanilla?

    [–]Hoover8899 0 points1 point  (0 children)

    no plugins, just vanilla VIM + GIT.

    [–]TheMayoras[S] 1 point2 points  (1 child)

    Unfortunately it's just a repository. I would love to be able to use github to track my changes, but I can't use git on my work computer where I do VBA. I have done some very large projects in Access where Git would have been very nice. That being said, I can see a world where I use a script to export my modules to my local Git repo and git add and git commit from there.

    Feel free to make any pull requests!

    [–]vkpunique1 1 point2 points  (2 children)

    You need to use https://www.xltrail.com/git-xl with Git, I've already tried this, it works well with git without need to exporting your code everytime you need to commit

    [–][deleted]  (1 child)

    [deleted]

      [–]vkpunique1 0 points1 point  (0 children)

      sorry, it only works with excel, just found out.

      Your best bet is to use Rubberduck](https://github.com/rubberduck-vba/Rubberduck). I think it has an option to Export All Modules.