Tag: Unit Testing

Unit testing Excel VBA – xlUnit demo

30 March 2010 by Ross McLean

Back in February I did a podcast with Mike Woodhouse, based around testing VBA code. Mike has written a unit testing frame work for VBA code, called xlUnit. Over the last few weeks I’ve been using xlUnit to help write a generic validation class for VBA, so I thought I would put together a little video of how the addin can be used to write tests for your code.

Its in 2 parts because you can only upload videos that are 10 minutes long to you tube.  The first part is the basics and in the second part I show some examples from my project.

You can find out more about xlUnit at Mikes blog, grumpy old programer:

Tags: ,
Categories: Addins, Code, Downloads, Spreadsheet Design, VBA, Videos • 13 Comments »

The MIE Podcasts – Mike Woodhouse

28 February 2010 by Ross McLean

What can you say about Mike Woodhouse that has not already been written? Probably loads. Mike works in London for a rather large international bank, hosts a blog (Grumpy Old Programmer), gets up to all kinds of cool stuff with Ruby, bosses stack overflow (10k rep!), and likes cricket. Oh and he’s not the least bit grumpy.

Mike Woodhouse, he actually looks like this.

In this podcast I chatted to Mike about Test Driven Development, and it place in the Excel/VBA landscape, we also discussed his add in XLUnit, design to help developers test VBA classes using the TDD approach.

Warning, unfortunately the MIE server was a bit rubbish when we did this podcast, so the recording is a poor.  I’ve spent an absolute age editing, but it’s still poor, but stick with it, its worth it.

Podcast: Play in new window | Download

Tags: ,
Categories: Podcasts • 1 Comment »