O'Reilly logo

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Second Edition by John Green, Stephen Bullen, Dennis Wallentin, Rob Bovey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2. Application Architectures

One of the first decisions to be made when starting a new project is how to structure the application. This chapter explains the various architectures we can use, the situations where each is most applicable, and the pros and cons of each choice.

Concepts

The choice of where to put the code for an Excel application is rarely straightforward. In anything but the simplest of situations there is a trade-off among numerous factors, including

  • Complexity—How easy will the chosen architecture be to create?

  • Clarity—How easy will it be for someone other than the author to understand the application?

  • Development—How easy will it be to modify the code, particularly in a team environment?

  • Extensibility—How easy is it ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required