I have exchanged a number of emails over the past couple of years with Stephen Bullen. He and I met up at an event here about 18 months ago, and what struck me is how sweeping his thoughts are about Office development generally. Sure, he’s an Excel expert, but he’s not a one-trick pony (although, most people would love to know that one trick!). And, I don’t always agree with him. For example, if I have the time, I will share my strong disagreement with some of the things he has said in a post where he claims that the future of VBA and .NET for Office developers is not clear. For the record: it’s clear, and I will explain why. BTW: Stephen, when are you going to go serious with a regular blog, bro? I think yours would be worthwhile.
Anyway, he was a principal author of a great book: Professional Excel Development from Addison Wesley.
His publisher sent me a copy, and I just had not had the time to look at it. I finally set aside some time to give it a thorough exploration. What stands out in my mind is that the sweeping knowledge he has of Office development really shows in this book.
He covers a number of topics that, while covered in different places, are rarely aggregated in a single tome as in this one. He covers Command Bar handling, writing Add-ins, VSTO, VB6, XML and Web services, VBA performance, Windows API calls, and Userform design best practices. There are other topics, but you can see that for the most part the ones I have listed are NOT really specific to Excel, although he gives each of them a clear Excel focus. If you consider yourself a developer mostly for Microsoft Word- you should still get this book.
Rock Thought for the Day: My team bought me a DVD as a present: Metallica- Some Kind Of Monster. What interests me most is the in-studio footage. I have spent loads of time in the studio (I was a sound-man for live shows for a band in the eighties), and I have respect for studio work. It becomes magical when a producer approaches the studio as another instrument in itself.