Читать книгу Excel 2019 Power Programming with VBA - Michael Alexander, Dick Kusleika - Страница 36

There is no simple, surefire recipe for developing an effective spreadsheet application. Everyone has his or her own style for creating such applications. In addition, every project is different and therefore requires its own approach. Finally, the demands and technical expertise of the people with whom (or for whom) you work also play a role in how the development process proceeds.

Spreadsheet developers typically perform the following activities:

 Determine the needs of the user(s)

 Plan an application that meets these needs

 Determine the most appropriate user interface

 Create the spreadsheet, formulas, macros, and user interface

 Test and debug the application

 Attempt to make the application bulletproof

 Make the application aesthetically appealing and intuitive

 Document the development effort

 Develop user documentation and Help systems

 Distribute the application to the user

 Update the application when necessary

Not all of these steps are required for each application, and the order in which these activities are performed varies from project to project. We describe each of these activities in the pages that follow. For most of these items, we cover the technical details in subsequent chapters.