Full RSS Feed or Comments Feed.

Access VBA: Bad DLL Calling ConventionFriday, October 23rd, 2009 with 3 Comments »

I’m happily going about my software development duties (and writing some cool updates to a large MS Access software product) when the whole thing crashes with an unexplainable error (I’ll tell you why it’s unexplainable later on). Oh, no! I really should have backed-up sooner!
Extensive debugging of the new code shows absolutely no issues [...]

Excel 2007: Transpose DataWednesday, June 10th, 2009 with 2 Comments »

A weird thing happened today with what should have been a simple exercise in data manipulation in Excel. Like most people I’m still trying to get to grips with where everything is in Office 2007 (I’ve lost count of the times I’ve heard:
“ARGH! the bloody ribbon! Where the hell is the <insert tool name>?”
Well, today [...]