VBA Developer’s Handbook

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 Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

WRITE BULLETPROOF VBA CODE FOR ANY SITUATIONThis book is the essential resource for developers working withany of the more than 300 products that employ the Visual Basic forApplications programming language. Written by recognized VBAexperts, it provides detailed coverage of a wide range of specificVBA programming challenges. Its careful, step-by-step instructionsand thousands of lines of code offer answers, while teaching you todevise new and creative solutions. The instruction applies equallyto all VBA environments, whether you are building standaloneapplications or customizing commercial products using theirbuilt-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 linkedlists, binary trees, stacks, and queues* Working with Windows system information, including memorystatus, 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 throughfolders, creating and deleting files* Adding sound and movies to VBA apps using Windows multimediaextensions* Tapping the system capabilities provided by the WindowsScripting Runtime library* Writing add-ins for the Visual Basic environmentNote: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.

Introduction xxiChapter 1: Manipulating Strings 1Chapter 2: Working with Numbers 93Chapter 3: Working with Dates and Times 143Chapter 4: Using VBA to Automate Other Applications 223Chapter 5: Creating Your Own Objects with VB Class Modules 271Chapter 6: Advanced Class Module Techniques 305Chapter 7: Searching and Sorting in VBA 369Chapter 8: Creating Dynamic Data Structures Using Class Modules 431Chapter 9: Retrieving and Setting System Information 485Chapter 10: Managing Windows Registry Data 597Chapter 11: The Windows Networking API 633Chapter 12: Working with Disks and Files 701Chapter 13: Adding Multimedia to Your Applications 809Chapter 14: Using the Scripting Runtime Library Objects 879Chapter 15: Writing Add-Ins for the Visual Basic IDE 931Appendix A: The Reddick VBA Naming Conventions, Version 6 999Index 1025