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?
Chapter 2: Working with Numbers
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 How Does VBA Store Numeric
Values?
Chapter 3: Working with Dates and Times
Using Built-In Numeric Functions Custom Math and Numeric Functions What Is a Date, and How Did
It Get There?
Chapter 4: Using VBA to Automate Other Applications
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 Automation Basics
Chapter 5: Creating Your Own Objects with VB Class
Modules
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 Why Use Class Modules?
Chapter 6: Advanced Class Module Techniques
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 Object Model Design
Principles
Chapter 7: Searching and Sorting in VBA
Developing Object Hierarchies Collections of Objects Creating and Using Custom Events Interface Classes and the Implements Keyword Other Advanced Considerations Timing Is Everything
Chapter 8: Creating Dynamic Data Structures Using Class
Modules
Using Arrays Sorting Arrays Searching Dynamic versus Static Data
Structures
Chapter 9: Retrieving and Setting System Information
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? VBA and System
Information
Chapter 10: Managing Windows Registry Data
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 Registry Structure
Chapter 11: The Windows Networking API
VBA Registry Functions Windows Registry Functions An Object Model for the Registry Basic Network
Functionality
Chapter 12: Working with Disks and Files
Advanced Networking Functionality The Built-In VBA Disk and
File Functions
Chapter 13: Adding Multimedia to Your Applications
File I/O If You Must The Windows API: Where the Real Power Is Using the Windows Common File Dialogs An Introduction to Windows
Multimedia
Chapter 14: Using the Scripting Runtime Library
Objects
One-Step Multimedia Understanding the Media Control Interface Putting MCI to Work Why Is This Chapter
Different?
Chapter 15: Writing Add-Ins for the Visual Basic IDE
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 Working with the IDE Object
Model
Appendix A: The Reddick VBA Naming Conventions, Version
6
Putting It Together: An Alternative Object Model COM Add-Ins Building a COM Add-In for the VBA IDE Changes to the
Conventions
IndexAn Introduction to Hungarian |
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
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
