WRITE BULLETPROOF VBA CODE FOR ANY SITUATION This book is the essential resource for developers workingwith any of the more than 300 products that employ the Visual Basicfor Applications 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.
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
Ken Getz is a senior consultant with MCW Technologies and splits his time between programming, writing, and training. He specializes in tools and applications written in Visual Studio .NET and Visual Basic. Ken is co-author of best-selling several books, including Access 2002 Developer's Handbooks with Paul Litwin and Mike Gunderloy, Visual Basic Language Developer's Handbook with Mike Gilbert, and VBA Developer's Handbook with Mike Gilbert (Sybex). He co-wrote several training courses for Application Developer's Training Company (www.appdev.com), including VB.NET, ASP.NET, Access 2000 and 97, Visual Basic 6, and Visual Basic 5 seminars.He has also recorded video training for AppDev covering VB.NET, ASP.NET, VB6, Access 2000, and Access 97. Ken is a frequent speaker at technical conferences and spoken often at Microsoft's Tech-Ed conference. Ken's also a technical editor for Access-VB-SQL Advisor magazine and a columnist for Informant Publications' asp.netPRO magazine.