VBA

Data Visualization: How (2 of 2)

Previously ... creating opportunities for insight ... The short answer, as you know, is that it's impossible to tell you how to be insightful and imaginative in a single blog post. All I can do is point you in the general direction, and (hopefully) ignite a little spark. What's the Goal? and, Where to Begin? I previously talked about the growing calls for effective data visualizations; we have access to all this great information, and there are insights in there…

Read More ...

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. Well, technologies come and go, and without going into the boring details, I've had to come up with a new way to generate the mini-bar charts along the left…

Read More ...

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 spreadsheets 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 cells ... and so on. However, some of the observed flightiness is specific to the UberSheet, while other weirdness happens…

Read More ...

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 along. And so, as I've finally made the leap to Office 2007, I had to come to terms with yet another VBA upgrade. I remember…

Read More ...

Sample Interview Questions for MS Project

I still get interesting, unsolicited pings from the meebo widget on my blog site. I've got a Pidgin plugin that connects to meebo, so when it says I'm available, I am definitely at the keyboard, hacking away at something - and usually able to answer the quick message. Still, sometimes I'm amazed at the depth and detail of the inquiries. Last week, I got into an interesting conversation with someone about MS Project interview questions. At first, I thought they…

Read More ...

Another Spam Graph – The Impact of Spammers Changing Tactics

Well, Raymond Chen has blown me away with his detail, but I have another take on the whole History of Spam thing - the impact of spammers changing message formats to get past the spam filters. My curious habit is to count my email into two categories; read vs. unread. This was originally meant to be a measure of the pointless cc: / newsletter / internal announcement stuff I receive everyday; I have Outlook set to mark an eMail as…

Read More ...