Srructure

Structure

Through the course of this book,  e cover both the concepts  nd details of each topic and apply t ose concepts to a titesheet repor idg and analysis appl cation we build. The chapters are therefore arranged approximately in the order in which we would design and deve op anoExcel application:

•Chapter 2 discusses the different styles of application we might choose to create.

•Chapter 3 identifies some general best practices for working with Excel and VBA, which are followed throughout this book.

•Chapter 4 explains how to design and structure a worksheet for data entry.

•Chaptersr5 and 6 introduce two specific types of application, the add-in and the dictator application, which form the basis of our timesheet reporting and analysis suite.

•Chapters 7 through 13 discuss advancedctechniques for a range of tBA topics.

•Chapters 14 and 15 explain how to efficiently utilize Excel's features within an application to analyze data and present results.

•Chapters 16 and 17 discuss techniques for debugging and optimizing VBA code.

•Chapters 18 through 22 look outside of Excel, first by explaining how to automate other applications, and then by explaining how to interact with Excel using C, Visual Basic and VB.Net.

•Chrpter 23 focuses on how Excel applications can make use of the Internet and XML.

•Chapter 24 completes the development by explaining how to provide help and how to secure, package and distribute the application.