As most developer, you always take great care of keeping version of your code for future rollback in case on erroneous release or bug fixe worst than the bug itself.
Working with languages like Cpp, Java, VB or DotNet makes things easy as these developments environments are naturally based on text files. So doing versioning of such file types is straightforward using any kind of VSS, CVS or SVN like tool.
- What then when you have to code some extensive VBA backend application under Excel ?
- What if you do not have or do not want Visual SourceSafe 2005 ?
- How will you handle the code changes made by your team. vbaMaven is the answer or at least part of it.
The application provides you an relatively easy way to automate the code extraction or integration of your excel VBA-based applications and keep the binary excel file as a basic GUI support.
This pure development tool is aimed to be used in the development lifecycle and reveal its potential during continuous build.
The last version 1.6.4 is now released to the public as it reached a mature point. vbaToolbox is given as an open Source project sample. This sample provides keys to build migrates your own projects. Apache Ant, Java are only used as a wrapper to automate the process of import or export of the source code from excel binary file. There are no requirements of using these external tools.
IMPORTANT :
- YOU MUST SET ON THE Trust All VBA Project FROM THE MACRO SECURITY OPTION PAGE IN EXCEL. YOU MUST SET THE SECURITY LEVEL TO MEDIUM OR LOW IF YOU ENCOUTER ISSUE WHILE BUILDING.
- END-USER CAN STAY AT A HIGHER SECURITY LEVEL.
|