VBA Developer's Handbook [With CDROM]

Finally there is a book that addresses advanced/state-of-the-art topics and program functionality in VBA. Most other VBA books end their discussion of object-oriented constructs and custom classes with a weak example of a collection class. This book goes way beyond into custom events, interface and implementation classes, and error handling. You're left with the feeling that you have access to all the armament VBA has to offer. Plus, there are lot's of tips & tricks for everything else, and lot's of code you need but haven't had the time to write yourself.

I've been programming part-time for work and school over the last 3 years. At my new full-time job I'm doing enough programming to warrant upgrading my skills. After reading many reviews I thought this book would be the perfect combination of real-world usability/practicality and some of the more theoretical stuff (like class modules) which I have never been able to pick up on my own.So far it has lived up to my expectations perfectly. I highly recommend this book.Brad

Having been dropped in the at the deep end at work, Having to re-create many Excel spreadsheets, in a very short time frame I found this book easy to understand and having the ready made code available helped make the work load a little lighter,As a previous review said " it's a VBA Cookbook" thanks.The way the information is grouped together with the little comments helped a great deal. 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. Thanks again.

As a more traditional Java/C++ developer I always scoffed at VBA and VB. When I began to develop using VB and VBA I was surprised to see how quickly and easily I could get things done and how well they worked. Now that I'm doing a number of more advanced things with multiple VBA enabled applications. This book has been a must have! Great examples, gets right to the good stuff, and skips the novice crap. If your looking to maximize your use of VBA this is a must have!

I have had this book for a long time and thought I should put in my .02 cents worth.Please do not let some of the earlier reviews fool or confuse you. This is a VBA based book. What does that mean? First off it means that it covers the common programming language 'Visual Basic for Applications' (VBA) that is used by Microsoft Office as well as third party products like Visio, AutoCAD, etc. Second, 'the language' VBA is the same 'programming language' which is used by 'the product' Visual Basic 5.0/6.0 from Microsoft. Think of it this way: Microsoft Visual C++ is a Windows development tool that uses the language C++. Microsoft Excel is a spreadsheet tool that happens to contain a full blown programming language, VBA. In addition, Microsoft happens to sell a 'Windows development tool', called Visual Basic which in turn contains a full blow programming language, VBA. Except for some minor differences, the VBA in Office 97 is the 'same' as the version in the product Visual Basic 5.0.This book does not pretend to be about 'the Visual Basic product' or any of the Microsoft Office products. It is about the 'common' programming language, VBA, which they (Visual Basic, Office, Visio, etc.) share! Some of the previous reviewers seem to be confused to these facts. While the current edition of this book covers the version of VBA released with Office 97, all of the code would work in Visual Basic 5.0 or 6.0, Visio, AutoCAD, etc. In fact, with the release of VBA 6.0, the 'common programming language' will be the same in Visual Basic 6.0 and Office 2000 and soon to be released versions of Visio, etc.This excellent book will NOT show you how to do database programming in Access, spreadsheet programming in Excel, or document programming in Word. It will NOT show you how to write ActiveX DLL's using the Visual Basic PRODUCT or do DCOM programming.This book WILL however show you how to write great VBA code (remember, the language) you can use in any of the previously mentioned products. In addition, you will obtain code that will help you get system information, perform 'correct' date calculations, access the system registry, use multimedia features and more! Remember, if I'm wrong, you can send the book back. Nevertheless, if you want to get some understanding about the VBA 'language', get this book.