Tous nos rayons

Déjà client ? Identifiez-vous

Mot de passe oublié ?

Nouveau client ?

CRÉER VOTRE COMPTE
VBA Developer's Handbook
Ajouter à une liste

Librairie Eyrolles - Paris 5e
Indisponible

VBA Developer's Handbook

VBA Developer's Handbook

Ken Getz, Mike Gilbert

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

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  2eme é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

Avantages Eyrolles.com

Livraison à partir de 0,01 en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
satisfait ou remboursé
Satisfait ou remboursé
Paiement sécurisé
modes de paiement
Paiement à l'expédition
partout dans le monde
Livraison partout dans le monde
Service clients sav@commande.eyrolles.com
librairie française
Librairie française depuis 1925
Recevez nos newsletters
Vous serez régulièrement informé(e) de toutes nos actualités.
Inscription