VBA Developer's Handbook

by Ken Getz, Mike Gilbert

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 IncludesManipulating text, numbers, and datesUsing automation to control other applicationsCreating objects using VBA class modulesUsing standard search and sort algorithms from within VBACreating standard dynamic data structures, including linked lists, binary trees, stacks, and queuesWorking with Windows system information, including memory status, screen info, mouse, keyboard, and power statusWorking with Windows Registry dataRetrieving and setting Windows networking informationWorking with the Windows file system, iterating through folders, creating and deleting filesAdding sound and movies to VBA apps using Windows multimedia extensionsTapping the system capabilities provided by the Windows Scripting Runtime libraryWriting add-ins for the Visual Basic environmentNote: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Genres: Reference, Computers, Programming

1104 pages, ebook

First published March 1, 1997

Reviews

[Anbarasan Anbu · Rating 5 out of 5]

This is really the best book i ever found.I have bought several VB books.None of them will explain as detail as this book.I highly recommend this book professional developers,In all this book answers a lot of every day problems with either the code for a quick fix or the information to help you in the right direction with a good grounding.

[Michael · Rating 3 out of 5]

An above average book on VBA from a time when VBA was taken seriously as a programming language. That being said, in the intervening decades Microsoft has grudgingly put half the content into libraries, and the book could be half as long.