Professional Excel Development [Electronic resources] : The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® نسخه متنی

Structure

Through the course of this book, we cover both the concepts and details of each topic and apply those concepts to a timesheet reporting and analysis application we build. The chapters are therefore arranged approximately in the order in which we would design and develop an Excel 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.

Chapters 5 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 advanced techniques for a range of VBA 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.

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