Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Second Edition

Chapter 11. Creating Cross-Version Applications

With the introduction of Office 2007 and Windows Vista, the life of Excel developers everywhere became much more complicated. As with each previous version of Office and Windows, we have to be sure our existing applications continue to run on these new platforms. Unlike the version updates of Office and Windows we have seen since the year 2000, however, Office 2007 and Windows Vista often require significant changes to our applications for them to continue to run correctly.

If at all possible we want to avoid writing applications that are version-specific to Office or Windows. As of this writing, it is still rare to encounter companies that have upgraded to Office 2007 or Vista across the board. Therefore, ...