Category for articles regarding VB.NET.
Recently another freelancer introduced GIT to me.
"Git is a free and open source distributed version control system designed to handle everything from small to very large projects with speed and efficiency." Copied this text from its home page, which you can find here.
From my point of view it is a very nice tool, written by a developer for developers.
But now for the actual topic of this article. Having a nice tool like GIT, it is still necessary to provide it with text files as changes to binaries cannot be displayed in a change history.
This raised the question as how to extract the source code from Excel VBA projects. Copying everything from modules, classes and forms into text files manually is painful and error prone.
Therefore the other freelancer suggested to provide me with some code he wrote long ago to extract VBA code from Excel binaries.
As I am very impatiant and could not wait for his code, I implemented a little tool in VB.NET.
VBaby - A tool to export and import VBA source code from Access and Excel files.
A new version of this free software including a GUI is available from the following link.
I do not provide support for the tool. However, if you find a bug let me know and I will try to fix it whenever I find time.
- Parent Category: Tech Blog