VBA For Dummies [Paperback]

John Paul Mueller (Author)

Book Description

Publication Date: January 10, 2007 | ISBN-10: 0470046503 | ISBN-13: 978-0470046500 | Edition: 5

VBA helps you put your computer in its place

Write programs that automate tasks and make Office 2007 work better 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 VBA IDE and program containers, debugging and controlling your programs, working with multiple applications using a single program, and the most exciting stuff -- programming for all the Office 2007 applications.

Discover how to

• Customize an application's interface
• Quick-launch a VBA program
• Store and modify information
• Use VBA with the Ribbon
• Understand object-oriented programming
• Avoid runtime errors

Editorial Reviews

From the Back Cover

VBA helps you put your computer in its place

Write programs that automate tasks and make Office 2007 work better 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 VBA IDE and program containers, debugging and controlling your programs, working with multiple applications using a single program, and the most exciting stuff — programming for all the Office 2007 applications.

Discover how to

• Customize an application's interface
• Quick-launch a VBA program
• Store and modify information
• Use VBA with the Ribbon
• Understand object-oriented programming
• Avoid runtime errors

About the Author

John Mueller is a freelance author and technical editor. He has writing in his blood, having produced 71 books and over 300 articles to date. The topics range from networking to artificial intelligence and from database management to heads-down programming. Some of his current books include a Windows power optimization book, a book on .NET security, and books on Amazon Web Services, Google Web Services, and eBay Web Services. His technical editing skills have helped more than 50 authors refine the content of their manuscripts. John has provided technical editing services to both Data Based Advisor and Coast Compute magazines. He has also contributed articles to magazines like DevSource, InformIT, Informant, DevX, SQL Server Professional, Visual C++ Developer, Hardcore Visual Basic, asp.netPRO, Software Test & Performance, and Visual Basic Developer.

Product Details

• Paperback: 432 pages
• Publisher: For Dummies; 5 edition (January 10, 2007)
• Language: English
• ISBN-10: 0470046503
• ISBN-13: 978-0470046500
• Product Dimensions: 9.4 x 7.4 x 1 inches
• Shipping Weight: 1.4 pounds (View shipping rates and policies)
• Average Customer Review: 2.4 out of 5 stars  See all reviews (35 customer reviews)
• Amazon Best Sellers Rank: #720,462 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

25 of 26 people found the following review helpful:

2.0 out of 5 stars Not great. Does have some value., April 27, 1999

By A Customer

This review is from: VBA for Dummies (Paperback)

I found this book nowhere near as helpful as other Dummies books on VBA programming. If you want another good starter book, I would recommend "Access 97 Programming for Dummies", which is full of real world examples that will help you understand VBA.

The author just seemed to get too cute with the subject matter. Also, the lack of real world examples really hurts this book. You can't step into object-oriented programming when you decide to invent your own objects for everything.

The explanation of how loops work is okay and the constants information is not bad. Overall, however, get a real technical book and try to learn it that way. It will be harder, but you will be better for it.

19 of 20 people found the following review helpful:

4.0 out of 5 stars Not just for dummies!, August 16, 2000

By 

Daryl R. Gibson "Writer, Editor, Technology Geek" (Las Vegas, NV USA) - See all my reviews
(REAL NAME)   

This review is from: VBA for Dummies (Paperback)

I picked up this book at a local bookstore (sorry Amazon), mainly because it was the only VBA book they had. This book allowed me to learn a lot of the concepts of VBA programming, in connection with Word 97 Annoyances, and VB&VBA Programming in a Nutshell. I recommend it to beginning VB programmers, like I was. It helped me get above the basics, fast. It's easy to discount these Dummies books, and most of them are so "Dummy" that they aren't worth the effort, but this one is a good book.

12 of 12 people found the following review helpful:

4.0 out of 5 stars Good transition from Excel VBA to VBA / VB, April 10, 2000

By 

D. Weisberg "kayak angler" (San Jose, CA USA) - See all my reviews
(REAL NAME)   

This review is from: VBA for Dummies (Paperback)

I learned VBA via Excel, but felt limited by my Excel-centric world and wanted get a broader VBA/VB perspective. By introducing topics like ActiveX controls and text stream objects with a minimum of hard-to-understand terminology, this book helped me reach my goal.