VBA for Dummies [Paperback]

Steve Cummings (Author)

Book Description

ISBN-10: 0764508563 | ISBN-13: 978-0764508561 | Publication Date: June 29, 2001 | Edition: 3rd

VBA For Dummies is a real card-carrying Dummies title with its fresh, conversational and irreverent style, yet it still covers VBA programming with real depth and accuracy. The book starts with a brief background on VBA and an explanation of key jargon and theoretical concepts. Then you jump right into the practical programming covering topics such as: VBA development environment; Visual Basic Editor; Meat and potatoes coding techniques; Database programming with VBA; Detailed Microsoft Office-specific tips and tricks; and Coverage of non-Microsoft VBA applications, including CorelDraw and Word Perfect.

Not all applications instantly give developers what they need out of the box. VBA For Dummies, 3rd Edition makes it easy for programmers to customize software from Microsoft and others with Visual Basic for Applications.

Editorial Reviews

From the Back Cover

Turbocharge your business software with Visual Basic for Applications

Now updated with coverage of Microsoft Office XP

Get up to speed with object-oriented programming Revised to cover Microsoft Office XP as well as upgrades of other VBA-enabled applications such as WordPerfect Office and AutoCAD, this friendly, accessible guide shows you step by step how to build and customize VBA applications to suit your business needs. all this on the bonus CD-ROM Trial versions of TX Text Control and Macro Magic ClipMate, PrettyCode.Print, and Macro Shareware versions of Express Sample VBA source code Six bonus chapters on Office programming and more System requirements: PC running Windows 95 or later, Windows NT4 or later. See the About the CD Appendix for details and complete system requirements.

Discover how to: Work with the Visual Basic editor Write and debug VBA programs Organize data with variables, arrays, and collections Design dialog boxes Use built-in VBA commands

Get smart! www.dummies.com Sign up for daily eTips at www.dummiesdaily.com Choose from among 33 different subject categories Get news you can use on everything from money to health to computers

About the Author

Steve Cummings is also the author of Microsoft Office 2000 Secrets and Home Banking with Quicken. A veteran programmer, he has written hundreds of articles for PC World and other magazines.

Product Details

• Paperback: 432 pages
• Publisher: For Dummies; 3rd edition (June 29, 2001)
• Language: English
• ISBN-10: 0764508563
• ISBN-13: 978-0764508561
• Product Dimensions: 9.1 x 7.4 x 1.2 inches
• Shipping Weight: 1 pounds
• Average Customer Review: 2.4 out of 5 stars  See all reviews (35 customer reviews)
• Amazon Best Sellers Rank: #2,353,069 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.