Office Zealot

There is an interesting post in the VSTO forum about VBA/VSTO/VSTA. The question is: ''Is VSTO/VSTA intended to replace VBA?'' http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1461382&SiteID=1 The future of VBA and VSTO/VSTA's role continues to be a hot topic. Excluding VSTA for a moment, VBA and VSTO are two different tools. Though ...

There really isn't a lot of advice out there on how to approach migrating to VSTO. I came to VSTO from the perspective of a long time Office VBA developer. For me, the things I spent the most time on were developing an understanding of .NET/COM interoperability and the draconian VSTO security and deployment model. If you're coming from ...

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 ...