VBA Developer's Handbook

by Ken Getz

VBA (Visual Basic for Applications) is a version of Visual Basic used for programming Microsoft Office and other applications. It is part of Office and more than 200 third-party software products, including AutoCAD, CorelDraw, and others. It allows developers to build customized applications that go far beyond what is possible with simple macros. This book covers version 6.3 of VBA and can be used with Office XP or Office 2000. About The Getz is Senior Consultant with MCW Technologies, a frequent speaker at developer conferences throughout the world, and contributing editor for Office & VBA Developer and Access-Office-VBA Advisor magazines. He is the coauthor of the best-selling Access Developer's Handbook. Gilbert is Product Manager with Microsoft's Developer Tools division, specializing in VBA. He is a columnist for Office & VBA Developer magazine and a regular speaker at Microsoft TechEd and other developer conferences. Table Of ?Introductionxxi 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. Appendix Reddick VBA Naming Conventions, Version 6. Index Special Programmers customizing applications for Microsoft Office or any of the more than 200 third-party products that support VBA

Genres: Reference, Computers, Programming

974 pages, Paperback

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.