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 alternative 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, it is a considered trade-off between numerous factors, including the following:
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? ...
Get Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
