Absolute Beginner's Guide to VBA

by Paul McFedries

Visual Basic for Applications (VBA) is a set of tools based on the Visual Basic language. The great thing about using it to enhance Office applications is that it's easier to learn than Visual Basic... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0789730766
• ISBN13: 9780789730763
• Release Date: March 2004
• Publisher: Que
• Length: 372 Pages
• Weight: 1.45 lbs.
• Dimensions: 0.9" x 7.4" x 9.1"

Customer Reviews

Great for Beginners

This is a fantastic book. It is definitely for absolute beginners but not to the host application for which you want to use it. It is for absolute beginners in VBA. If you already develop advanced applications at macro levels, this book is definetily for you. Even if you don't it's a great book and you will learn VBA, but you'll get more out of it if you have a medium to advance knowledge in the host application you want to use: Microsoft Office, AutoCAD, and all other vendors who have bought the licenses to use VBA. I'd buy this book, even if you already are a power user in office applications. It gives you the basics of VBA as the language unbiased from application-specific orientaton.

Great book for Beginners

This is really "the absolute beginners guide to VBA" the title says it all. It provides an excellent way to familiarize yourself with the basics of the language. I bought this book because another VBA book (AutoCAD VBA 2004) was a little over my head, and now i have a feel for the language which enables me to understand the other book. however, this book talks about the basics of the language, with brief introductions to Office applications. in order to actually program in Word, Excel, etc. you should probably buy another book explaining, in detail, the objects associated with those programs.

Good, but definitely for beginners.

The best thing about this book is that it takes a look at typical ways in which VBA gets applied to virtually each and every member of the MS Office family. It will get you going with VBA from scratch in short order, and it is not a cumbersomely long book. The only caveat is that if you do actually know how to program it may come across a little too much as though you don't. But it says it is for absolute beginners so there is no real fault there. If you know how to program but don't know the VB editor too well it will do the job for you.

Integrate MS Office Applications

This book is where to start if you are trying to automate Word, Excel, PowerPoint, Outlook, or Access. It covers each application's object model (with practical examples) which gives you the confidence to develop in each application. Absolute Beginner's Guide to VBA's main stength is its conciseness (only ~400 pages with lots of pictures). It is very easy to read; I read the book in 10 hours. There is only one additional subject that should have been covered in an introductory book: starting applications from within another application - i.e. starting PowerPoint from within Access. The clearest explanation of this topic is in the book "Office XP Development with VBA". I also recommend this book.

Great introduction to VBA

The book is what it says: for ABSOLUTE beginners. If you have some computer experience and a working knowledge of the MS Office suite and you are ready to begin leveraging the power of VBA, this book is for you. If you are afraid of VBA, have tried VBA before and failed, or know nothing about programming, this book is for you. I found the book to be of the appropriate length ~350 pages or so. There was also plenty of side bar information that did a great job of explaining WHY you would or would not want to do something. Coverage also included "good to know" gotchas that would definately cause a beginner some heartburn.The Good:The book starts out with the obvious introductory items like recording macros, building custom macros, programming control structures (if-then, for loops, etc). The book also has an entire chapter that covers "objects". They are well written, easy to follow, and definately target the beginner.At about Chapter 7 the book begins dedicating one chapter to each of the MS Office (2000) suite - starting with Word. Then Excel, Powerpoint, Access, and even a chapter on Outlook. All the chapters had good BEGINNER examples. The chapter that covers Access has an example of how to move data between Excel and Access - quite useful.The last few chapters cover more intermediate topics like debugging, custom dialogs, and toolbars. As before, the book does a good job of introducing and illustrating (through useable examples) how to do the task at hand.All chapters and examples are on topic. Little or no author dialog, no extemporaneous page fill, and no pay-per-page bloat to distract you from the code.The Bad:Coverage of each of the specific Office applications is good for a BEGINNER and given the obvious limitations of an introductory book, so don't expect that you are getting a great Excel programming book or an outstanding Access programming book. The Access examples use ADO which is not a bad thing by itself, but the examples use a fairly advanced coding format (short-cut notation) that many beginners may find hard to follow. The Access chapter and code examples leave out most if not all coverage of integrating "Forms" and "Reports" into your VBA code, which is a huge miss IMHO - minus half star. Coverage of printing and print formatting information with VBA is (or is nearly) nonexistent - minus half star.If you are already familiar with VBA and you are looking for a beginners VBA book for a specific Office product, this may not be the book for you.If you have always been intimidated by VBA or you "just never could get the hang of it", this is definately the book for you.Excellent value for the price.CM