#SOURCETREE ALTERNATIVE HOW TO#
#SOURCETREE ALTERNATIVE CODE#
#SOURCETREE ALTERNATIVE PROFESSIONAL#

by using RubberduckвЂ™s bulk import/export functionality, see above). This goes hand in hand with exporting/importing your source files (e.g.

#SOURCETREE ALTERNATIVE CODE#

Sometimes it may be easier to edit the source code outside of the VBA editor. If you have setup things correctly, coding in VBA is suddenly a lot more fun:

#SOURCETREE ALTERNATIVE PROFESSIONAL#

However, for many professional programmers, this is too cumbersome and error prone.ДЇortunately, AtlassianвЂ™s free Git desktop client SourceTree together with xltrailвЂ™s free Git extension Git XL proves to be a powerful combo: You just have to track your Excel workbook with Git and SourceTree will show you the diff - no error prone exporting/importing of VBA modules required! Instead of SourceTree you can also use the command prompt if you prefer ( git diff etc.).

#SOURCETREE ALTERNATIVE HOW TO#

Many users export/import their modules manually or halfway automatically (see also How to use Git hooks to version-control your Excel VBA code) and track the exported text file with a version control system like Git. The fact that VBA code is embedded in the Excel workbook itself makes it a difficult task to get it under source control. The following screenshot shows RubberduckвЂ™s Refactor > Reorder Parameters dialog: You can disable that by going to Rubberduck > Settings > General Settings, then uncheck Show splash screen at startup. Tip: By default, Rubberduck shows a splash screen every time you startup the VBA editor. Alternative: If bulk import/export is all you need, you can also use the Excel VBA Developer Tools. In RubberduckвЂ™s Code Explorer, you can use Import. Bulk import and export of all VBA modules: Without Rubberduck, you have to export/import each VBA module separately.Rubberduck also has a Find all references functionality that makes it easy to see where a certain function is called from.

For example, it shows you if you use a variable that is not assigned, if you have unused procedures or if a parameter is implicitly passed by reference.

Code Inspection: Rubberduck has multiple categories of code inspection that point out possible issues and allow you to improve your code quality with usually a single click.

Very useful if you have modules with a lot of code and many functions! It doesnвЂ™t stop at the module level but allows to quickly jump to a specific function or variable declaration.

Navigation: RubberduckвЂ™s Code Explorer is a modern replacement for the built-in Project Explorer.

Indentation: Automatically indent your code either on function, module or project level.

Refactoring: You can easily rename functions and add, remove and reorder function arguments.

It covers a lot of functionality with the most important ones being: Rubberduck is probably the most prominent free VBA add-in. And just because Microsoft hasnвЂ™t invested in either the language itself nor the VBA editor during the last 20 years, it doesnвЂ™t mean that you canвЂ™t pimp your VBA coding experience with a few extra tools! Table of Contents Despite all the new possibilities to program Excel (like JavaScript add-ins, VSTO and others), VBA remains the most popular language when it comes to automate and enhance Excel.

Sourcetree alternative