VBA for Dummies

by John Paul Mueller

Book Overview

VBA helps you put your computer in its place

Write programs that automate tasks and make Office 2007 workbetter for you

If your computer is becoming your boss instead of your servant, start using VBA to tell it what to do Here's the latest on the VBAIDE and program containers, debugging and controlling yourprograms, working with multiple applications using a singleprogram, and the most exciting stuff -- programming for all...

• Format: Paperback
• Language: English
• ISBN: 0470046503
• ISBN13: 9780470046500
• Release Date: December 2006
• Publisher: For Dummies
• Length: 432 Pages
• Weight: 0.20 lbs.
• Dimensions: 0.9" x 7.4" x 9.4"

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!