During my initial foray into VSTO office development two years ago, I was particularly frustrated by the severe lack of documentation on the subject. Unfortunately, it seems this is still something of a problem. It took me hours of googling the other day just to find a definitive list of all the ribbon callback signatures. …

Yesterday I was researching what changes Microsoft made to VBA 7*—which shipped with Office 2010—and stumbled upon this VBA assessment test. Intrigued, I took the 50 question quiz. It was extremely tempting to cheat by confirming my assumptions before I answered some of the questions, but I resisted the urge. (I’m just so honorable.) Officially …

I just lost 60 minutes of my life… and I’m never getting it back. About a year ago my dad asked me to write him an Excel addin that would shuffle some data around, do some minor aggregations, yadda yadda yadda. Nothing major. Being the good son I am, I got started right away. Gosh, …