VBA Developer's Handbook

Ken Getz, Mike Gilbert

1074 pages, parution le 25/05/2001 (2^eme édition)

Ajouter à une liste

Indisponible

Résumé

WRITE BULLETPROOF VBA CODE FOR ANY SITUATION

This book is the essential resource for developers working with any of the more than 300 products that employ the Visual Basic for Applications programming language. Written by recognized VBA experts, it provides detailed coverage of a wide range of specific VBA programming challenges. Its careful, step-by-step instructions and thousands of lines of code offer answers, while teaching you to devise new and creative solutions. The instruction applies equally to all VBA environments, whether you are building standalone applications or customizing commercial products using their built-in VBA programmability.
Coverage Includes

Manipulating text, numbers, and dates
Using automation to control other applications
Creating objects using VBA class modules
Using standard search and sort algorithms from within VBA
Creating standard dynamic data structures, including linked lists, binary trees, stacks, and queues
Working with Windows system information, including memory status, screen info, mouse, keyboard, and power status
Working with Windows Registry data
Retrieving and setting Windows networking information
Working with the Windows file system, iterating through folders, creating and deleting files
Adding sound and movies to VBA apps using Windows multimedia extensions
Tapping the system capabilities provided by the Windows Scripting Runtime library
Writing add-ins for the Visual Basic environment

CONTENTS

Introduction

Chapter 1: Manipulating Strings

How Does VBA Store Strings?
Unicode versus ANSI
Using Built-In String Functions
Putting the Functions Together
Searching for and Replacing Text
Gathering Information about Strings
Converting Strings
Working with Substrings

Chapter 2: Working with Numbers

How Does VBA Store Numeric Values?
Using Built-In Numeric Functions
Custom Math and Numeric Functions

Chapter 3: Working with Dates and Times

What Is a Date, and How Did It Get There?
The Built-In VBA Date Functions
Odd Behaviors
Displaying Values the Way You Want
Beyond the Basics
Finding a Specific Date
Finding the Next Anniversary
Finding the nth Particular Weekday in a Month
Working with Workdays
Manipulating Dates and Times
Working with Elapsed Time
Handling Time Zone Differences

Chapter 4: Using VBA to Automate Other Applications

Automation Basics
Creating Object Instances
Controlling Other Applications
Creating Automation Solutions with Microsoft Office
Example: Word as a Report Writer
Example: Populating an Excel Worksheet
Tapping into Events Using WithEvents

Chapter 5: Creating Your Own Objects with VB Class Modules

Why Use Class Modules?
How Class Modules Work
A Simple Example: A Text File Class
Using Property Procedures
Creating Enumerated Types
Applying Class Module Techniques to the Windows API

Chapter 6: Advanced Class Module Techniques

Object Model Design Principles
Developing Object Hierarchies
Collections of Objects
Creating and Using Custom Events
Interface Classes and the Implements Keyword
Other Advanced Considerations

Chapter 7: Searching and Sorting in VBA

Timing Is Everything
Using Arrays
Sorting Arrays
Searching

Chapter 8: Creating Dynamic Data Structures Using Class Modules

Dynamic versus Static Data Structures
How Does This Apply to VBA?
Creating a Stack
Creating a Queue
Creating Ordered Linked Lists
Creating Binary Trees
The Tree Class
Adding a New Item
Adding a New Node: Walking the Code
Traversing the Tree
Traversing a Tree: Walking the Code
The Sample Project
What Didn't We Cover?

Chapter 9: Retrieving and Setting System Information

VBA and System Information
The API Functions
Computer and Operating System Information
Keyboard Information
Memory Status
Mouse Information
Non-Client Metrics
Power Status
Screen and Window Information
System Colors

Chapter 10: Managing Windows Registry Data

Registry Structure
VBA Registry Functions
Windows Registry Functions
An Object Model for the Registry

Chapter 11: The Windows Networking API

Basic Network Functionality
Advanced Networking Functionality

Chapter 12: Working with Disks and Files

The Built-In VBA Disk and File Functions
File I/O If You Must
The Windows API: Where the Real Power Is
Using the Windows Common File Dialogs

Chapter 13: Adding Multimedia to Your Applications

An Introduction to Windows Multimedia
One-Step Multimedia
Understanding the Media Control Interface
Putting MCI to Work

Chapter 14: Using the Scripting Runtime Library Objects

Why Is This Chapter Different?
Testing the Simple FileSystemObject Methods
Copying and Moving Files and Folders
The Drives Collection
The Drive Object
The Folder Object
The Files Collection
The File Object
The TextStream Object
Working with the Dictionary Object

Chapter 15: Writing Add-Ins for the Visual Basic IDE

Working with the IDE Object Model
Putting It Together: An Alternative Object Model
COM Add-Ins
Building a COM Add-In for the VBA IDE

Appendix A: The Reddick VBA Naming Conventions, Version 6

Changes to the Conventions
An Introduction to Hungarian

Index

L'auteur - Ken Getz

Ken Getz has written several best-selling books on Microsoft Access, VBA, and Visual Basic. His Access development books have sold more than 250, 000 copies worldwide. Ken is currently working on courseware, books, and video training on .NET, and has co-recorded a 25-hour series on ASP.NET for AppDev. He is a frequent speaker at technical conferences and DevDays, and regularly writes for a number of trade publications including MSDN Newsletter and asp.netPRO. Recent books by Ken include:

Caractéristiques techniques

	PAPIER
Éditeur(s)	Sybex
Auteur(s)	Ken Getz, Mike Gilbert
Parution	25/05/2001
Édition	2^eme édition
Nb. de pages	1074
Format	19 x 22,7
Couverture	Broché
Poids	1844g
Intérieur	Noir et Blanc
EAN13	9780782129786
ISBN13	978-0-7821-2978-6