About

I’ve been programming since I was first allowed to use the ICL mainframe during my (brief) stay at University. Of course, from the University’s point-of-view, that single was year probably a year too many, but that’s dichotomies for you. Or not. Anyway, the introduction to mainframe BASIC via teletype was enough to nudge me down the slippery slope to a career in computing, where I’ve spent the last 30 years, mostly employed, mostly within the investment banking industry. I’ve been an operator, programmer, team leader, project manager and department head but these days I try to get away with calling myself “Geek In Residence” for the business department within the very large German bank that pays my wages and where I am involved in developing novel (to us and hopefully to our customers) financial products as well as computer-based tools.

This is where I rant, pontificate, expound about computer stuff. To a fairly large extent it’s biased toward things that I encounter at work, because that’s where I do most of my development work these days (children, I find, have a tendency to eat into one’s leisure development time).

Since I use a slightly peculiar mixture of technologies at work, principally Excel/VBA, Ruby (on and off Rails) and a screwy mix of database platforms, the complete mix may not be to everyone’s taste. I’ll try to keep the categorisation reflecting what’s going on.

I’m defiantly middle-aged and not just grumpy while programming – it’s my natural state and I like it. At time of writing my hair is receding and I have a partly-slipped disc,  one wife, two children, two dogs, a hamster and a house to keep me occupied.

Until recently I could describe myself as “forty-something”. Those days are gone forever.

And I hate Lotus Notes.

7 Responses to About

  1. AM says:

    Are there any good VBA profiling tools other then by Brothersoft? I have seen that you referred to one you are using or possible written yourself so you may be aware of what is out there.. thanks in advance! Cheers.

  2. mikewoodhouse says:

    I’m pretty sure (don’t have it to hand at the moment) that the CD that’s in the back of the completely excellent “Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA” (http://www.amazon.co.uk/Professional-Excel-Development-Definitive-Applications/dp/0321262506/ref=sr_1_2?ie=UTF8&s=books&qid=1222558399&sr=8-2) has a DLL that does profiling. I think it’s similar to my tool, except that mine works entirely within Excel.

    I’ve never bothered with anything else – my tool works well enough for my needs.

  3. Ramzani says:

    Dear Sir,

    I just attended MS demo on their new Hospital application (I think comes from Burumgrad Hospital in Thailand) which MS called Amalga. During the demo, they showed an impressive Hospital Referral letter generating application using CodePlex.

    The demo have the this neat button with MS Word where the doctor just press few buttons and wala the Word is ready within 2 seconds.

    I have been hunting for what is CodePlex. Admittedly it has been a while I have been programming but I can pick it up quickly as I have done Excel Macros, Delphi programming even CICS (IBM mainframe) stuff.

    Do you know of any good books or any good forums discussing this CodePlex. I was hoping you would write a book on this asap – CodePlex for Dummies. I think I would be interested in a boot camp if there is one near Kuala Lumpur

    Appreciate your feedback.

    Thank you

    best regards

  4. Dr Loser says:

    Love the hamster.

    Does it look like Geoff? I’ve always wanted a hamster> I shall call it “Challinger.”

  5. Hi Mike,

    saw your 2008 posts about unit tests for Excel VBA.

    Wanted to ask you two things:

    1) do you have that unit test framework up somewhere? like in github?

    2) how do you implement version control software for excel vba?

    thank you 🙂

  6. was not able to check the notify me of follow-up comments via email checkbox earlier, so i am putting in another comment. Apologies for this.

  7. Troy Smith says:

    Hi Mike, I am also very interested in xlunit, but can’t get it to work in Excel 2007+. Did you ever have an update for this, or some ideas on how it could be modified for newer versions of excel. Many thanks for your contribution to the community.

Leave a comment