Definitive Guide to Excel VBA (Definitive Guides) and over one million other books are available for Amazon Kindle. Learn more
eTextbook Trial
$0.00
Try the eTextbook free for 7 days on your Fire, iOS, Android, PC, or Mac.

Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Definitive Guide to Excel VBA, Second Edition Paperback – July 21, 2003


See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle
"Please retry"
Paperback, July 21, 2003
$18.24 $0.57
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Get Up to 80% Back When You Sell Us Your Books
NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Series: Definitive Guides
  • Paperback: 936 pages
  • Publisher: Apress; 02 edition (July 21, 2003)
  • Language: English
  • ISBN-10: 1590591038
  • ISBN-13: 978-1590591031
  • Product Dimensions: 1.8 x 7 x 9 inches
  • Shipping Weight: 3.3 pounds
  • Average Customer Review: 3.9 out of 5 stars  See all reviews (19 customer reviews)
  • Amazon Best Sellers Rank: #2,004,096 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Michael Kofler holds a Ph.D. in computer science from Graz Technical University in Austria. He has written a number of successful computer books on topics such as Visual Basic, Visual Basic .NET, and Linux. Michael is the author of The Definitive Guide to MySQL 5, Third Edition and Definitive Guide to Excel VBA, Second Edition from Apress.

Customer Reviews

I also feel that the author should have covered the Range names a little better.
Charles L. Byrne
Compared to Walkenbach books (like Excel 2002 / 2000 power programming with VBA) and many others, this book is truly worth its title.
Marc
Example code is scarce and I couldn't get some of the sample code to work at all.
Manny Braun

Most Helpful Customer Reviews

104 of 105 people found the following review helpful By johare4 on January 4, 2001
Format: Paperback
Probably the two books to compare with are Walkenbach's "EXCEL 2000 Power Programming", and Green's "EXCEL 2000 VBA". A related book that is a description of the language with nothing about the EXCEL object model is Lomax "VB & VBA in a Nutshell".
Kofler can be cryptic at times. As explanation, he says (p. 336) "The long and the short of it is that you [dear reader] will not be spared the opportunity to do a bit of experimenting yourself". An example of this brevity is the treatment of the MsgBox, which is used to interrogate the user of the spreadsheet and offer a variety of choices. Kofler provides an example on p. 220, and refers the reader to the online help for amplification. In contrast, Julitta Korol offers over 7 pages of examples and tables using this function. The pro of brevity is many features can be outlined, and the reader can find the additional info for free. The con is that the reader won't appreciate the full utility of the feature without perusing the online help in some detail.
Compared to Walkenbach, Kofler has more about features new to EXCEL 2000. For instance, Kofler has subroutines illustrating the use of the Implements statement in VBA, while Walkenbach lists it as a statement with no comment, Green doesn't even mention it. Lomax has a complete discussion pp. 373 - 375. Kofler also describes the manipulation of files using the FSO (File System Objects) Library (pp. 245ff.), a new feature.
Compared to Green, Kofler is almost entirely exposition, while pp. 343-695 of Green is a listing of the EXCEL 2000 and VBE object models, which I personally find not too useful. However, because the first 245 pages of Green is compact, I find it easier to find information there.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
27 of 28 people found the following review helpful By Weiqin Xie on August 21, 2002
Format: Paperback
I won't say this book is "the only Excel VBA book you will need" -- there is no such kind of thing for programming books. However, I like to say it is one of the best and definitive guides to Excel VBA. The most important thing is that there are several advanced topics you won't find on the other popular Excel VBA books (such as Excel 2002 VBA programminer's Reference by Stephen Bullen, John Green et al. or Excel 2002 Power Programming with VBA by John Walkenback): for instance, recursion, details of random numbers generation, matrix functions, automatic data reporting, OLAP functionality and using Excel as ActiveX server. However, I also must say this book is definitely not for the beginners to learn VBA.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
31 of 33 people found the following review helpful By Marc on January 28, 2002
Format: Paperback
Compared to Walkenbach books (like Excel 2002 / 2000 power programming with VBA) and many others, this book is truly worth its title. Its clear and very well structurated plan means all information can be found easily and everything understood without pain. This is paramount since a book main and unique goal is to transmit information. Its design and layout, clear, eye-pleasing and professional, strengthens this crucial aspect. With Walkenbach, the reader has to collect elements throughout all chapters them combine them to get an idea of a particular topic!!! With this book, the reader knows what he'll find and where. For example, all error handling is included in one part while all functions are sorted by theme (math, date etc.) It's incredible that having a coherent and clear organization, which should be basic, is not in Walkenbach books!?
Furthermore, this book reveals many important and little documented points tied to Excel VBA, ranging from range and cells to many critical points like external data access with true database programs, which are even not dealed in some self-proclamed 'expert' books, like Walkenbach's. Besides, it exhibits many trips and tricks that allow fast, clean programs and avoir many troubles by grouping all points linked to a particular problem.
Third, the writting is not terse: with irony, and a great amount of objectivity, qualities which seem to evaporate in Walkenbach and others (which very often sound like a Microsoft ad), it clearly explains and demonstrates the limits and bugs of Excel VBA.
Fourth, the companion CD Rom is truly useful, loaded with many pratical and real-life examples and solutions. Again, Walkenbach, after saying virtually every page the HE is the author, the creator and so forth, with its constant I-do-this mentality, provides a software wich is not usable since the reader has to send a coupon card!
Finally, this is the book to have for truly mastering Excel VBA, without pain but with efficiency.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
22 of 23 people found the following review helpful By Manny Braun on August 28, 2002
Format: Paperback
When I purchased this book I assumed that because I have some VB experience and am fairly well versed with Excel that this book would fill the gap for me to pick up VBA. Sadly, this was not the case. Specifically, the nuts and bolts of interest to a VBA beginner are for the most part placed in one mammoth 150 page chapter. The frustrating subject of addressing and manipulating ranges, especially across sheets, is not covered in any depth. Example code is scarce and I couldn't get some of the sample code to work at all. Some of the language is convoluted possibly a result of being translated from the original german. In fairness, I did not get much past chapter 5 so perhaps once I'm up to speed the rest of the book may prove more helpful. Also the index is quite good especially compared to some other computer books I've seen.
If you're a beginner I would recommend J. Walkenbach's website on VBA for Excel. Also, chapter 14 of "Excel For Chemists" by E.J. Billo is an excellent source for learning how to reference ranges.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Most Recent Customer Reviews


More About the Author

Discover books, learn about writers, read author blogs, and more.