« Standards-based CSS web design tool | Main | Careful with filenames when deploying to Linux »
Unit testing VBA projects
By Shawn Bradley | August 27, 2007
One of my current projects requires exclusive development in Microsoft Access using VBA. Having put my hand to the plow, so to speak, of extreme programming, I was quite unwilling to return to traditional methods of development. Yet it appeared I was constrained by my inability to drive a VBA app from outside of the Access IDE.
Fortunately, after some poking around on Sourceforge, I was able to locate an NUnit-based project graciously contributed by rharwood. This project is called VBAUnit (naturally) and is available here. The owner of VBAUnit explains that this was a quick and dirty implementation, since VBA development is not a mainstay, but it certainly did the trick for me. I would not have survived this current project with even a modicum of sanity had I not discovered this valuable contribution. If you are doing, or plan to do, any work in VBA, I highly recommend utilizing this resource.
Topics: Software Development |