depotnanax.blogg.se - Repository of excel vba examples

#Repository of excel vba examples how to#
#Repository of excel vba examples software#
#Repository of excel vba examples code#

#Repository of excel vba examples code#

Joe now wants to enhance his existing code or make a fix to it.

Joe now has something in Git that performs at least a little bit of the functionality he wants.

We will assume that the first time Joe uses Git with VBA is at point B.

From A Joe starts laying down code until he has something to put into a code library.

The developer, we’ll call him Joe, is just starting the project.

At point “A” there is no working code.

We’re going to assume a development process that looks like this: VBA Development Flow Using Git with VBA We’re going to use Git with VBA to enable us to perform configuration management of our VBA code. Our tool for VBA configuration management is Git. We’re going to see how we can add functionality to the VBA IDE to allow us to perform configuration management of our VBA code. If you want to do VBA code configuration management you have to do it outside the VBA IDE. The native VBA IDE provides no configuration management capabilities.

The VBA IDE (Integrated Development Environment, that thing you activate when you hit Alt-F11 from your Excel workbook) is your world for developing the VBA code for your Excel work of art. Remember, we assumed that we’re the only developer of our VBA project.) Here is an excellent description of Git. (We’re not going to use the distributed aspects of Git. Git is a distributed version control system developed by Linus Torvalds to control the different versions of the Unix kernel.

#Repository of excel vba examples software#

A widely used tool for software configuration management is Git. Version control and configuration management are pretty much interchangeable terms for the same concept. Longer, more descriptive file names could do that but we don’t typically use file names that way. Unfortunately, Rev_1 and Rev_2 don’t describe the difference between the two versions. You are using the file name to control the versions or manage the configurations. Each file represents a different version or configuration of your work. Have you ever created an Excel VBA work of art and used the file names Work_of_Art_Rev_1.xlsm, Work_of_Art_Rev_2.xlsm, etc? If so, you’re using version control to manage the changes of your work of art as you develop and improve it. What is version control or configuration management? Xltrail focuses on using Git for version control of your Excel workbook. Xltrail and Rubberduck are examples of using Git with VBA.

There are not many websites devoted to using Git with VBA. There are many websites devoted to VBA (do a web search on “VBA”). There are many websites devoted to Git (do a web search on “Git”). This is a brief overview of Git and why you might want to use Git with VBA. Git is designed for multiple developers but we’re not going to use those capabilities. There are, of course, exceptions, but we’re going to focus on how an individual can use Git with VBA to more effectively configuration manage their VBA code. We’re going to focus on an individual developing VBA code on their own rather developing code as a team. We’re going to see how we can integrate Git into the Excel VBA universe to improve our ability to version control or configuration manage our VBA source code.

#Repository of excel vba examples how to#

This is the first in a series of articles describing how to use Git with VBA.