Bullen S., Bovey R., Green J. - Professional Excel Development [2005, CHM, ENG] + Code

Книги и журналы » Компьютерная литература » Программы от Microsoft

Professional Excel Development. The Definitive Guide to Developing Applications Using Microsoft Excel and VBA

Год: 2005
Автор: Stephen Bullen, Rob Bovey, John Green / Стивен Буллен, Боб Бови, Джон Грин
Жанр: Пособие
Издательство: Addison-Wesley Professional
ISBN: 0-321-26250-6
Язык: Английский
Формат: CHM
Качество: Изначально компьютерное (eBook)
Количество страниц: 936

Описание: Finally, there's a book that treats Excel as the powerful development platform it really is, and covers every facet of developing commercial-quality Excel applications.
This is not a book for beginners. Writing for professional developers and true Excel experts, the authors share insider's knowledge they've acquired building Excel applications for many of the world's largest companiesincluding Microsoft. Professional Excel Development demonstrates how to get the utmost from Excel, addressing everything from application architectures through worksheet and userform design, charting, debugging, error handling and optimizing performance. Along the way, the authors offer best practices for every type of Excel development, from building add-ins through interacting with XML Web services. Coverage includes
• Building add-ins to provide new Excel functions
• Designing effective worksheets, userforms and other user interface elements
• Leveraging Excel's powerful data analysis features
• Creating sophisticated custom charts
• Handling errors, debugging applications and optimizing performance
• Using class modules and interfaces to create custom objects
• Understanding Windows API calls: when to use them, and how to modify them
• Adding worksheet functions with C-based XLLs
• Programming with databases
• Controlling external applications from Excel
• Integrating with Visual Basic 6, VB.NET and Visual Studio Tools for Office
• Using XML to import and export data and communicate with Web services
• Providing help, securing, packaging and distributing
The accompanying CD-ROM contains the book's sample timesheet application at every stage of construction, with detailed code comments. It also includes many examples of the concepts introduced in each chapter and a collection of the authors' Excel development utilities.
[spoiler="Примеры страниц"]

[/spoiler]
[spoiler="Описание CD:"]
Welcome to the companion CD for Professional Excel Development, by Stephen Bullen, Rob Bovey, and John Green. Copyright 2005.

SYSTEM REQUIREMENTS
The following are the minimum and recommended system requirements for using this CD:

Operating Systems
Windows 98, Windows NT, Windows 2000, Windows ME, Windows XP

Processor/RAM
The CD requires no additional RAM other than the minimum required by the operating system you are running.

Available Hard Drive Space
The CD does not require any files to be installed, but may require up to 25 MB if you choose to copy all the examples, application versions, and utilities to your hard drive.

Required Software
Most of the example files, application files, and utilities will run with a standard installation of Excel 2000, Excel 2002, or Excel 2003, except where noted below.

Most of the conceptual examples will also work with Excel 97; the example application will not.

Examples for Chapter 13 - Programming with Databases require Microsoft Access 2000, 2002, or 2003

Examples for Chapter 18 - Controlling Other Applications require a standard installation of Microsoft Office Professional 2000, 2002, or 2003

Examples for Chapter 19 - XLLs and the C API require Visual C++ 6.0 or Visual C++.NET

Examples for Chapter 20 - Combining Excel and Visual Basic 6 require Visual Basic 6.0

Examples for Chapter 21 - Writing Add-ins with Visual Basic 6 require Visual Basic 6.0

Examples for Chapter 22 - Using VB.NET and the Visual Studio Tools for Office require Visual Basic.NET and the Visual Studio Tools for Office

Examples for Chapter 23 - Excel, XML and Web Services require Office 2003 Professional or a standalone version of Excel 2003. The sample Web Service requires Visual Basic.NET and a server running Internet Information Services (IIS).

Examples for Chapter 24 - Providing Help, Securing, Packaging and Distributing require the Microsoft HTML Help Workshop

CONTENTS
This CD contains the following:

Application folder

The Application folder contains a fully-working version of the example timesheet application at each stage of its construction, corresponding to each chapter in the book. Each file is heavily commented to identify the changes made for that chapter. It would have been too artificial to update the application for some of the chapters; in these cases, the corresponding folder contains a small text file stating that no updates were made.

Concepts folder

The Concepts folder contains a sub-folder for each chapter in the book, which contain example files to demonstrate the concepts introduced in the chapter. For best results, we recommend you have these files open and refer to them while reading the chapter.

Tools folder

The Tools folder contains sub-folders for a number of the authors’ utilities, which we use every day and believe rank as "must have" utilities. See the MustHaveTools.htm file in the Tools folder for more information.

INSTALLATION AND USE
The example workbooks found in the Application and Concepts folder can be opened directly from the CD. No installation is required, but for best results, we recommend you copy the files from the CD to your hard disk before use.

The utilities found in the Tools folder can be installed by double-clicking each file to start their installation routine.

In some configurations of Office and Windows, it is possible that the example files will not work correctly when run from the CD. In these cases, we recommend you copy the files to your hard disk, remove their read-only attribute and open them from there.

THIRD-PARTY SOFTWARE
For technical support with the utilities included in the Tools folder, please contact [email protected]
[/spoiler]