WRITE BULLETPROOF VBA CODE FOR ANY SITUATION
This book is theessential resource for developers working with any of the more than 300 productsthat employ the Visual Basic for Applications programming language. Written byrecognized VBA experts, it provides detailed coverage of a wide range of specificVBA programming challenges. Its careful, step-by-step instructions and thousandsof lines of code offer answers, while teaching you to devise new and creativesolutions. The instruction applies equally to all VBA environments, whether youare building standalone applications or customizing commercial products usingtheir built-in VBA programmability.
Manipulating text, numbers, and dates
Using automation tocontrol other applications
Creating objects using VBA class modules
Usingstandard search and sort algorithms from within VBA
Creating standard dynamicdata structures, including linked lists, binary trees, stacks, andqueues
Working with Windows system information, including memory status,screen info, mouse, keyboard, and power status
Working with Windows Registrydata
Retrieving and setting Windows networking information
Working withthe Windows file system, iterating through folders, creating and deletingfiles
Adding sound and movies to VBA apps using Windows multimediaextensions
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.