VBA For Dummies [Paperback]

John Paul Mueller (Author)

Book Description

Publication Date: September 22, 2003 | ISBN-10: 0764539892 | ISBN-13: 978-0764539893 | Edition: 4th

* 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

Editorial Reviews

From the Back Cover

Customize Microsoft® Office, WordPerfect®, CorelDRAW®, and more!

You can take charge with VBA and tweak your software to meet your needs

The "B" in VBA could stand for "boss" because VBA makes you the boss of your software. This handy guide gives you the credentials for the job. Find out how easily you can use VBA to create shortcuts, eliminate repetitive tasks, adapt databases, make a frustrating interface more user-friendly, and so much more.

The Dummies Way

• Explanations in plain English
• "Get in, get out" information
• Icons and other navigational aids
• Tear-out cheat sheet
• Top ten lists
• A dash of humor and fun

About the Author

John Paul Mueller is a technical editor and consultant. He has authored or coauthored 58 books and more than 200 articles on everything from database management to artificial intelligence.

Product Details

• Paperback: 408 pages
• Publisher: For Dummies; 4th edition (September 22, 2003)
• Language: English
• ISBN-10: 0764539892
• ISBN-13: 978-0764539893
• Product Dimensions: 9.2 x 7.4 x 0.9 inches
• Shipping Weight: 1.3 pounds
• Average Customer Review: 2.4 out of 5 stars  See all reviews (35 customer reviews)
• Amazon Best Sellers Rank: #1,173,858 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.