VBA for Dummies

By John Paul Mueller and Steve Cummings

Book Overview

* Gives programmers, software developers, and advanced users of Microsoft Office applications all the key concepts necessary to write VBA programs for the new Office "X" * Fully updated to cover all the changes in the newest release of Office * VBA (Visual Basic for Applications) is the primary development tool for all applications in the Microsoft Office suite-Access, Excel, and Word-and according to Microsoft, more than 2.6 million programmers currently use VBA * Since VBA is also licensed to other software developers and vendors, it is built into some non-Microsoft, third-party software; programs that include VBA can be tailored to fit specific business needs * Shows programmers how to build applications with VBA and covers all the essentials, including: VBA visual programming tools, recording and modifying macros, basic VBA programming, running VBA programs, using the VBA Editor, debugging and error trapping, plus more advanced topics, such as built-in VBA commands and working with objects * Author has written and/or cowritten more than fifty-eight technology books

• Format: Paperback
• Language: English
• ISBN: 0764539892
• ISBN13: 9780764539893
• Release Date: October 2003
• Publisher: Wiley & Sons, Incorporated, John
• Length: 408 Pages
• Weight: 1.45 lbs.
• Dimensions: 0.9" x 7.5" x 9.1"

Customer Reviews

Learning VBA couldn't be easier

I was ready to give up trying to get Excel data to show graphic changes based on new input, when I found this book. It helped me learn fast but gave the small details that are often ignored in other computer-training books. I was even able to manipulate Visio programs -- something the book doesn't cover -- because of the author's flexible approach to teaching VBA for all Office applications, even Visio. Because of this book, I have never felt more confident venturing into a new learning area.

Easy for the Beginner

The author does a great job of getting you started and then helping you do something useful. I had used both Word and Excel extensively before I started reading this book, so I was already familiar with application usage. Unlike some books that would have assumed I didn't know anything about the application just because I've never written code, this one got me going with code right away. It wasn't long before I was writing some really helpful macros for both Word and Excel.The author demonstrates that it's possible to do a lot more than you think you can do with either Word or Excel, but encourages you to use the right application for the job. I found the chapter on working with multiple applications the most useful because the examples are so practical and perform so well. This is a great book for someone who has never coded in VBA before and really wants to do something practical fast.

Outstanding Guide to VBA

This book is typical Dummies in that it gets you started quickly and doesn't leave out any of the details. I needed to learn how to write macros in VBA for my current job, but wasn't sure I could learn how without spending a lot of time and money. This book got me going very quickly. It tells you everything you need to know about VBA.The book would have been worthwhile if it stopped and teaching me VBA, but it didn't. The book went on to tell me about Office programming specifics. I now feel fairly competent to work with Word and Excel. The Access coverage probably could have been a little more extensive, but the book did get me started. All of the examples I've tried work very well and I think they teach interesting things.I contacted the author with some questions and was amazed when he actually answered and didn't act like I was some kind of idiot. He helped answer a few questions I had about the book and told me how to download the sample code when I couldn't find it. This book and its author has been a real help when I needed it.

Great new edition on VBA!

This new edition covers VBA programming with XML, which was most important to me considering how much Microsoft touted Office 2003's XML usage. I'm using this book to create VBA programs, debug, OOP, etc. The code examples are great too. I've already built several new Office 2003 apps.

VBA with Ease!

John Mueller does a great job of showing how to build applications with VBA in the For Dummies friendly style. This book is chocked full of practical, consise code examples that can be applied to everyday work experiences. I recommend this book to all who want to learn how to use VBA with ease!