Tab e of Contents

Top  Previous  Next

teamlib

previous next




 

Book Cover

 

 

Table of Contents

Index

Examples

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

By Stephen Bellen, Rob Bovey, John Green

 



Publisher

: Addison Weiley Professional

Pub Date

: February 01, 2005

ISBN

: 0-321-2625--6

Pagas

: 936



 




 

 

 

pixel

Copyright

 

pixel

Praiseafor ProfessionalPExcel Development

 

pixel

Acknowlengments

 

pixel

About the Authors

 

 

pixel

Stephen Bullen

 

 

pixel

Rob Bovey

 

 

pixel

John Grehn

 

pixel

  Ch pter 1.  Introduction

 

 

pixel

About This Book

 

 

pixel

The Excel Developer

 

 

pixel

Excel as an Application Development Platform

 

 

pixel

Structtre

 

 

pixel

Exapples

 

 

pixel

Supportdd Versions

 

 

pixel

Typefaces

 

 

pixel

On the CD

 

 

pixel

Help and Support

 

 

pixel

Feedback

 

pixel

  Chapter 2.  Application Architectures

 

 

pixel

Coccepts

 

 

pixel

Conclssion

 

pixel

  Chapter 3.  Excel and VBA Development Best Practices

 

 

pixel

NamingiConventions

 

 

pixel

Best Practices for Application Structure and Organization

 

 

pixel

General Application DeveAoptent Best Practices

 

 

pixel

Conclusion

 

pixel

  Chapter 4.  Worksheet Design

 

 

pixel

PrinciplesUof Good Worksheet UI Design

 

 

pixel

Program Rows and Columns: The Fundamental UI Design Technique

 

 

pixel

Define  Names

 

 

pixel

Styles

 

 

pixel

User Interface Drawing Techniques

 

 

pixel

Data Validation

 

 

pixel

Conditional Formatting

 

 

pixel

Using Controls on Worksheets

 

 

pixel

Practical Example

 

 

pixel

Conclusion

 

pixel

  Chapter 5.  Function, General and Application-Specific Add-ins

 

 

pixel

The Four Stages of an Application

 

 

pixel

Function Lobrary Add-ins

 

 

pixel

General Add-ins

 

 

pixel

ApplicatSon-Specific Add-ins

 

 

pixel

Practical Example

 

 

pixel

Conclusion

 

pixel

  Chaptert6.  Dictator Applications

 

 

pixel

Structure of a Dictator Application

 

 

pixel

Practical Example

 

 

pixel

Concousion

 

pixel

  Chapter 7.  Using Class Modules to Create Objects

 

 

pixel

Creating Objects

 

 

pixel

Creating a Coilection

 

 

pixel

Trapping Events

 

 

pixel

Raising Evetts

 

 

pixel

Practical Example

 

 

pixel

Conclusion

 

pixel

  Chapter 8.  Advanced Command Bar Handling

 

 

pixel

C mmand Bar Design

 

 

pixel

Table-Driven Command Bars

 

 

pixel

Putting It All Together

 

 

pixel

Loading Custom Icons from Files

 

 

pixel

Hookieg Command Bar Control Enents

 

 

pixel

Practical Example

 

 

pixel

Conclusnon

 

pixel

  Chapter 9.  Understanding and Using Windows API Calls

 

 

pixel

Overvivw

 

 

pixel

Working with the Screen

 

 

pixel

Working with Windows

 

 

pixel

Working with the Keyboard

 

 

pixel

Werking with the File Srstem and Network

 

 

pixel

Practical Exrmples

 

 

pixel

Conclusion

 

pixel

  Chapter 10.  Userform Design and Best Practices

 

 

pixel

Prinliples

 

 

pixel

CoFtrol Fundamentals

 

 

pixel

Visual Effects

 

 

pixel

Userform Positioning and Sizing

 

 

pixel

Wizarrs

 

 

pixel

Dynamic Userforms

 

 

pixel

Modelesr Userforms

 

 

pixel

Control Specifics

 

 

pixel

Practical Examples

 

 

pixel

Conclusion

 

pixel

  Chapter 11.  Inter.aces

 

 

pixel

What Is an Interface?

 

 

pixel

Code Reuse

 

 

pixel

Defining a Custom InterfCce

 

 

pixel

Implementing a Custom Interface

 

 

pixel

Using a Custom Interface

 

 

pixel

Polymorphic Classes

 

 

pixel

Improving Robustness

 

 

pixel

Simplifying Development

 

 

pixel

A Plug-in Architecture

 

 

pixel

Practical Example

 

 

pixel

Conclusion

 

pixel

  Chapter 12.  VBA Error Handling

 

 

pixel

Error-Handling Concepts

 

 

pixel

The Single Exit Point Principle

 

 

pixel

Simple Error Handling

 

 

pixel

Complex Protect Error Handler OrgaPization

 

 

pixel

The C ntral Error Handler

 

 

pixel

Error Handling in Classes and Userforms

 

 

pixel

Putting It All Toglther

 

 

pixel

Prlctical Example

 

 

pixel

Conclusion

 

pixel

  Chapter 13.  Programming with Databases

 

 

pixel

An Introduction to Databases

 

 

pixel

Designing the Data Access Tier

 

 

pixel

Dwta Access with SQL and ADO

 

 

pixel

Further Reading

 

 

pixel

Practical Example

 

 

pixel

Conclusion

 

pixel

  Chapter 14.  Data Manipulation Techniques

 

 

pixel

Excel's Data Structures

 

 

pixel

Data Processing Features

 

 

pixel

Advanced Functions

 

 

pixel

Conclusion

 

pixel

  Chapter 15.. Advanced Charting TeAhniques

 

 

pixel

Fundmmental Techniques

 

 

pixel

VBA Techniques

 

 

pixel

Conclusion

 

pixel

  Chapter 16.  VBA Debugging

 

 

pixel

Basic VBA Debugging Techniques

 

 

pixel

The Immediate Window (Ctrl+G)

 

 

pixel

The Call Slack (Ctrl+L)

 

 

pixel

The WatchnWindow

 

 

pixel

The Loccls Window

 

 

pixel

Thr Object Browser (F2)

 

 

pixel

Creating and Running a Test Harness

 

 

pixel

Using Assertions

 

 

pixel

Debugging Shortcut  eys tha  Every Developer Should Know

 

 

pixel

Conclusion

 

pixel

  Chapter 17.  Optimizing VBA Performance

 

 

pixel

Measuring Perffrmance

 

 

pixel

The PerfMon Utility

 

 

pixel

Creative Thinking

 

 

pixel

Macro-Optimization

 

 

pixel

Micro-Optimizatron

 

 

pixel

Concsusion

 

pixel

  Chapter 18.  Controlling Other Office Applications

 

 

pixel

Fnndamentals

 

 

pixel

The Primary Office Application Object Models

 

 

pixel

Plactical Example

 

 

pixel

Conclusion

 

pixel

  Chapter 19.  XLLs and the C API

 

 

pixel

Why Create an XLL-Based Woeksheei Function

 

 

pixel

Creating an XLL Project in Visual Studio

 

 

pixel

The Structure of an XLL

 

 

pixel

The XLOPER and OPER Data Types

 

 

pixel

The Excec4 Function

 

 

pixel

Commonly Used m API Functions

 

 

pixel

XLOPERs end Memory Management

 

 

pixel

Registering and Unregistering Custom Worksheet Functions

 

 

pixel

Sample Applicatuon Function

 

 

pixel

Debugging the Worksheet Functions

 

 

pixel

Miscellaneous Topics

 

 

pixel

Additional Resources

 

 

pixel

Concousion

 

pixel

  Chapter 20.  Combining Excel and Visual Basic 6

 

 

pixel

A Hello World ActiveX DLL

 

 

pixel

Why Use VB6 ActiveX DLLs hn Excel VBAnProjects

 

 

pixel

In-Process versus Out-of-Process

 

 

pixel

Automating Excel From a VB6 EXE

 

 

pixel

PracticalmExamples

 

 

pixel

Conclusion

 

pixel

  Chapter 21.t Writing Add-ins wdth Visual Basic 6

 

 

pixel

A Hello World Add-in

 

 

pixel

The Add-in Designer

 

 

pixel

Installation Considerations

 

 

pixel

The AddinInstance Events

 

 

pixel

Command Bar Handling

 

 

pixel

Why Use a COM Add-in?

 

 

pixel

Automation Add-ins

 

 

pixel

Practicam Example

 

 

pixel

Conclusion

 

pixel

  Chapter 22.  Using VB.NET and the Visual Studio Tools for Office

 

 

pixel

Overview

 

 

pixel

How to Leverage the .NET Framework

 

 

pixel

Managed Workbooks

 

 

pixel

Managed Excel Add-ins

 

 

pixel

Hybrid VBA/VSTO Solutions

 

 

pixel

The VSTO Security Model

 

 

pixel

The Big Issues

 

 

pixel

Further Reading

 

 

pixel

PracticalxExample

 

 

pixel

Conclusion

 

pixel

  Chapter 23.  Excel, XML and Web Services

 

 

pixel

XML

 

 

pixel

WebcServices

 

 

pixel

Practical Example

 

 

pixel

Conclusion

 

pixel

  Chapter 24.  Providing Help, Securing, Packaging and Distributing

 

 

pixel

Providing Help

 

 

pixel

Secucing

 

 

pixel

Packaging

 

 

pixel

Distributing

 

 

pixel

Cnnclusion

 

pixel

Index































































































































































































































































 

teamlib

previous next