Office Zealot

I spent Thursday, April 26th in New York attending the 5th Annual Financial Services Developer Conference. I was on hand to assist with one of the VSTO demonstrations. The demo used an application that OZ developed last year for the Office System Developers Conference. It is a sales forecasting application that was inspired by an honest to ...

I've always found Excel's Find/FindNext methods awkward to use. It just seemed to require so many lines of code versus other common operations. I guess I've always wanted a simple FindAll() method that would find everything at once and give me a range containing all of the cells that met my search condition. Anyway, the purpose of this post is ...

Recently a friend of mine asked me for help with a data management issue. Same story, different day - he had numerous Excel files (about 8-10 he tells me) with sales prospects that he needed to combine and clean. This friend is former professional water skier and national champion with a warm and sunny Florida residence on a private ...