VBA Developer's Handbook, 2nd Edition

by Ken Getz; Mike Gilbert

• ISBN13: 9780782153330
• ISBN10: 078215333X
• Format: eBook
• Copyright: 2006-02-01
• Publisher: Sybex

Summary

WRITE BULLETPROOF VBA CODE FOR ANY SITUATIONThis 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 Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Table of Contents

Introduction	p. xxi
Manipulating Strings
Working with Numbers
Working with Dates and Times
Using VBA to Automate Other Applications
Creating Your Own Objects with VB Class Modules
Advanced Class Module Techniques
Searching and Sorting in VBA
Creating Dynamic Data Structures Using Class Modules
Retrieving and Setting System Information
Managing Windows Registry Data
The Windows Networking API
Working with Disks and File
Adding Multimedia to Your Applications
Using the Scripting Runtime Library Objects
Writing Add-Ins for the Visual Basic IDE
The Reddick VBA Naming Conventions, Version 6
Index
Table of Contents provided by Publisher. All Rights Reserved.