VB & VBA in a Nutshell: The Language
Publisher: O'Reilly Media
Final Release Date: October 1998
Pages: 652

The online documentation of VB/VBA language components seems to follow the 80/20 rule: the basic facts that you need to use a language statement are provided in the documentation. But the additional 20 percent that you need to use it effectively or to apply it to special cases is conspicuously absent. To a professional VB/VBA programmer, though, this missing 20 percent of the language's documentation isn't a luxury, it's a necessity. And inVB & VBA in a Nutshell: The Language, it finally is available.The bulk of the book consists of an alphabetical reference to the statements, procedures, and functions of the VB/VBA language. Each entry has a standardized listing containing the following information:

  • Its syntax, using standard code conventions
  • Differences in the operation of the keyword in a macro environment (e.g., in Office) and in Visual Basic, if there are any
  • A list of arguments accepted by the function or procedure, if any
  • A description of the data type returned by a function
  • The finer points of a keyword's usage that are often omitted from or blurred over by the documentation
  • Tips and gotchas that include undocumented behaviors and practical applications for particular language elements -- a section particularly invaluable for diagnosing or avoiding potential programming problems
  • A brief, nonobvious example that illustrates the use of the keyword
Also included in VB & VBA in a Nutshell: The Language is a brief overview of the VB/VBA language, including:
  • Basic VBA programming concepts, such as its data types and its support for variables, constants, and arrays
  • Error handling in VBA applications
  • Object programming with VBA
  • Using VBA with particular applications. Excel and Project are utilized to show how to work with an application's integrated development environment and to take advantage of its object model Regardless of how much experience you have programming with VBA, this is the book you'll pick up time and time again both as your standard reference guide and as a tool for troubleshooting and identifying programming problems.
VB & VBA in a Nutshell: The Language is the definitive reference for Visual Basic and VBA developers.
Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyVB & VBA in a Nutshell: The Language
 
4.6

(based on 10 reviews)

Ratings Distribution

  • 5 Stars

     

    (9)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (1)

Reviewed by 10 customers

Sort by

Displaying reviews 1-10

Back to top

(1 of 1 customers found this review helpful)

 
1.0

Q: update...? it is 12 years, eh?

By HOWARD NYC

from 10003

About Me Developer, Educator, Maker

Pros

  • Accurate
  • Lend itsself to updating

Cons

  • Older than five years

Best Uses

    Comments about oreilly VB & VBA in a Nutshell: The Language:

    USEFUL BUT OLD

     
    5.0

    Excellent Reference

    By Thomas B.

    from Undisclosed

    Comments about oreilly VB & VBA in a Nutshell: The Language:

    I've had this book in my collection for well over a year now and it makes for a great reference when programming in VB6. It is organized in a manner that makes looking up the formatting of particular methods quick and easy. It provides examples and programming gotchas that help when implementing a method you haven't previously used or rarely use.

    (3 of 3 customers found this review helpful)

     
    5.0

    VB & VBA in a Nutshell: The Language Review

    By kt

    from Undisclosed

    Comments about oreilly VB & VBA in a Nutshell: The Language:

    This book worked quite well for me as I needed a reference for writing VBA code in MS Access, Word, and Excel. It fills in the large gap where Microsoft help leaves you.

    I would definitely recommend this book if you already have learned the basics of Visual Basic. The chapters before the reference section are quite good and it answered many questions I had regarding the use of VBA in the MS Office apps.

    (1 of 1 customers found this review helpful)

     
    5.0

    VB & VBA in a Nutshell: The Language Review

    By Jose Benitez

    from Undisclosed

    Comments about oreilly VB & VBA in a Nutshell: The Language:

    This book has never let me down. I would have paid 3 times as much for a book like this. A classic reference work.

     
    5.0

    VB & VBA in a Nutshell: The Language Review

    By Charles McAuley

    from Undisclosed

    Comments about oreilly VB & VBA in a Nutshell: The Language:

    I'm a C++ programmer with lots of experience. I have resisted VB for years until recently when I inherited a very poorly written VB app that needed to be fixed and updated. I understood OOP, what I wanted was quick and dirty straight facts. Give me syntax and no fluff, give the the real world experience and the all the gotchas so I would not pulled the hair out of my head. This book gave me that and much more, in short it saved my skin. I fixed the bad VB app and now I'm the company hero. This book travels everywhere with me and my laptop. It's worth its weight in gold. As much as I hate to admit it I actually like VB now that I have had to dig in. Don't get me wrong I still like C++ as well and now there is room in my life for both. Cannot rate this book highly enough an off the positive side of the scale of truly useful.

    Charles :-)

     
    5.0

    VB & VBA in a Nutshell: The Language Review

    By Joe Federico

    from Undisclosed

    Comments about oreilly VB & VBA in a Nutshell: The Language:

    Fantastic book! It bridges the gap between beginner and intermediate/advanced programmer by cutting right to the chase. Excellent reference book! If you learn/find only 1 solution, you'll undoubtedly find many, it would have already paid for itself over and over. When I'm looking for a computer book I always check if O'Reilly has one on the subject before considering any other publisher. Keep up the great work!

     
    5.0

    VB & VBA in a Nutshell: The Language Review

    By Mike

    from Undisclosed

    Comments about oreilly VB & VBA in a Nutshell: The Language:

    This is without a doubt an excellent book on VB/VBA.

    It summarized the language in a very concise and

    efficient manner. It addresses such vital and

    crucial topics as COM/DCOM, error handling, and

    function usage.

    I recommend this book to anyone who needs to

    make use of VB/VBA in a production environment. The

    only subject it does not address is calling Win32

    API from VB.

     
    5.0

    VB & VBA in a Nutshell: The Language Review

    By Bob Heckel

    from Undisclosed

    Comments about oreilly VB & VBA in a Nutshell: The Language:

    Great book, supplements VB's Help very well, especially "Gotcha" issues and code samples. Unfortuntely, the code samples are not online.

     
    5.0

    VB & VBA in a Nutshell: The Language Review

    By Anonymous

    from Undisclosed

    Comments about oreilly VB & VBA in a Nutshell: The Language:

    As a VB client-server programmer, I hardly have the time to wait for VB's HTML help to appear,much less search through it! This book is really in a class by itself as far as VB references go. It's the perfect size to keep right at hand, yet it contains the answer to virtually every question I've asked it.

    The encyclopedia-type language reference is preceded by exceptional discussions of VB data types, classes, object models, and error handling, and also includes several interesting and useful

    appendices. About the only thing I've not found in it is an ASCII chart. The language element entries are peppered with sidebars on relevant topics, all entries are discussed with remote automation issues in mind, and great examples abound (the entry for the Format function runs to 9 pages, mostly examples). If you program VB for a living, you've got to have this book close by.

     
    5.0

    VB & VBA in a Nutshell: The Language Review

    By Michael.Welter

    from Undisclosed

    Comments about oreilly VB & VBA in a Nutshell: The Language:

    I find this book is good for learning new techniques, or as a reference guide. I can find many, many examples of excellent code in this book. It's an excellent resource.

    Displaying reviews 1-10

    Back to top

     
    Buy 2 Get 1 Free Free Shipping Guarantee
    Buying Options
    Immediate Access - Go Digital what's this?
    Ebook: $31.99
    Formats:  DAISY, PDF
    Print & Ebook: $43.99
    Print: $39.99