Hacking the Google Chart API from Excel

a bit of code on a Saturday night …I’ve written before about a simple way to measure and report IT value to the business – quantifying alignment with strategic initiatives  project spend in context. It all culminated with a single, simple slide – numbers, with some Tufte-esque Sparklines thrown in. Click on the picture for [...]

Excel 2007 is a BOB system (Bag’O'Bugs)

I am getting seriously aggravated with the flighty behavior of Excel 2007. Yes, I acknowledge that the spreadheets in question is quite complicated …

shared VBA modules in an XLA file
database read/write using ADO
array-manipulation for ranges of cells (see this post)
lots of macro (VBA) logic to control look/feel of the tabs
code to automatically insert formulae into [...]

Does Excel 2007 VBA have Sneaky Hidden Issues?

I’ve done a lot of coding over the past few years, on a number of platforms – but since I’m not a full time developer, it’s typically limited to VBA, PHP, SQL, some simple web stuff. Still, I’ve developed some tools that people use – and need to carry forward as the underlying technology moves [...]