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

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

اصطلاحنامه مجموعه ها مرورالفبایی لغت نامه دهخدا

➟

جستجو در لغت نامه

بیشتر

کتابخانه شخصی پرسش از کتابدار ارسال منبع

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

Stephen Bullen, Rob Bovey, John Green

| ،

افزودن به کتابخانه شخصی

میخواهم بخوانم

درحال خواندن

خوانده شده

ارسال به دوستان

آدرس پست الکترونیک گیرنده :

آدرس پست الکترونیک فرستنده :

نام و نام خانوارگی فرستنده :

پیغام برای گیرنده ( حداکثر 250 حرف ) :

کد امنیتی را وارد نمایید

ارسال

جستجو در متن کتاب

بیشتر

تنظیمات قلم

فونت

اندازه قلم

+ - پیش فرض

حالت نمایش

روز نیمروز شب

➟

جستجو در لغت نامه

بیشتر

لیست موضوعات

Praise for Professional Excel Development

Acknowledgments

About the Authors

Chapter 1. Introduction

About This Book

The Excel Developer

Excel as an Application Development Platform

Supported Versions

Help and Support

Chapter 2. Application Architectures

Chapter 3. Excel and VBA Development Best Practices

Naming Conventions

Best Practices for Application Structure and Organization

General Application Development Best Practices

Chapter 4. Worksheet Design

Principles of Good Worksheet UI Design

Program Rows and Columns: The Fundamental UI Design Technique

User Interface Drawing Techniques

Data Validation

Conditional Formatting

Using Controls on Worksheets

Practical Example

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

The Four Stages of an Application

Function Library Add-ins

General Add-ins

Application-Specific Add-ins

Practical Example

Chapter 6. Dictator Applications

Structure of a Dictator Application

Practical Example

Chapter 7. Using Class Modules to Create Objects

Creating Objects

Creating a Collection

Trapping Events

Practical Example

Chapter 8. Advanced Command Bar Handling

Command Bar Design

Table-Driven Command Bars

Putting It All Together

Loading Custom Icons from Files

Hooking Command Bar Control Events

Practical Example

Chapter 9. Understanding and Using Windows API Calls

Working with the Screen

Working with Windows

Working with the Keyboard

Working with the File System and Network

Practical Examples

Chapter 10. Userform Design and Best Practices

Control Fundamentals

Userform Positioning and Sizing

Dynamic Userforms

Modeless Userforms

Control Specifics

Practical Examples

Chapter 11. Interfaces

What Is an Interface?

Defining a Custom Interface

Implementing a Custom Interface

Using a Custom Interface

Polymorphic Classes

Improving Robustness

Simplifying Development

A Plug-in Architecture

Practical Example

Chapter 12. VBA Error Handling

Error-Handling Concepts

The Single Exit Point Principle

Simple Error Handling

Complex Project Error Handler Organization

The Central Error Handler

Error Handling in Classes and Userforms

Putting It All Together

Practical Example

Chapter 13. Programming with Databases

An Introduction to Databases

Designing the Data Access Tier

Data Access with SQL and ADO

Further Reading

Practical Example

Chapter 14. Data Manipulation Techniques

Excel's Data Structures

Data Processing Features

Advanced Functions

Chapter 15. Advanced Charting Techniques

Fundamental Techniques

Chapter 16. VBA Debugging

Basic VBA Debugging Techniques

The Immediate Window (Ctrl+G)

The Call Stack (Ctrl+L)

The Watch Window

The Locals Window

The Object Browser (F2)

Creating and Running a Test Harness

Using Assertions

Debugging Shortcut Keys that Every Developer Should Know

Chapter 17. Optimizing VBA Performance

Measuring Performance

The PerfMon Utility

Creative Thinking

Macro-Optimization

Micro-Optimization

Chapter 18. Controlling Other Office Applications

The Primary Office Application Object Models

Practical Example

Chapter 19. XLLs and the C API

Why Create an XLL-Based Worksheet Function

Creating an XLL Project in Visual Studio

The Structure of an XLL

The XLOPER and OPER Data Types

The Excel4 Function

Commonly Used C API Functions

XLOPERs and Memory Management

Registering and Unregistering Custom Worksheet Functions

Sample Application Function

Debugging the Worksheet Functions

Miscellaneous Topics

Additional Resources

Chapter 20. Combining Excel and Visual Basic 6

A Hello World ActiveX DLL

Why Use VB6 ActiveX DLLs in Excel VBA Projects

In-Process versus Out-of-Process

Automating Excel From a VB6 EXE

Practical Examples

Chapter 21. Writing Add-ins with Visual Basic 6

A Hello World Add-in

The Add-in Designer

Installation Considerations

The AddinInstance Events

Command Bar Handling

Why Use a COM Add-in?

Automation Add-ins

Practical Example

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

How to Leverage the .NET Framework

Managed Workbooks

Managed Excel Add-ins

Hybrid VBA/VSTO Solutions

The VSTO Security Model

Further Reading

Practical Example

Chapter 23. Excel, XML and Web Services

Practical Example

Chapter 24. Providing Help, Securing, Packaging and Distributing

توضیحات

افزودن یادداشت جدید

Practical Example

It would be too artificial to extend either the PETRAS timesheet add-in or the PETRAS reporting application to control one or more of the other Office applications. Excel's features are sufficient for our analysis and reporting requirements. If we were to do so, however, we would use the procedures shown in Listing 18-11 to Listing 18-14, which should be considered to be the practical examples for this chapter.