|
Definitive Guide to Excel VBA, Second Edition | 
 enlarge | Author: Michael Kofler
Publisher: Apress
Category: Book
List Price: $54.99
Buy New: $24.99
You Save: $30.00 (55%)
New (18) Used (12) from $22.00
Rating:  17 reviews
Sales Rank: 541122
Media: Paperback
Edition: 02
Pages: 936
Number Of Items: 1
Shipping Weight (lbs): 3.3
Dimensions (in): 9.1 x 6.7 x 1.9
ISBN: 1590591038
Dewey Decimal Number: 005.54
EAN: 9781590591031
ASIN: 1590591038
Publication Date: July 21, 2003
Availability: Usually ships in 1-2 business days
| |
| Also Available In:
|
| Accessories:
|
| Similar Items:
|
| Editorial Reviews:
Product Description
New in the second editon:
- Covers Excel 2000 to 2003
- Explains how to access Web Services from Excel programs
- Shows you how to process lists and XML data with Excel 2003
Microsoft's Excel is not only a powerful spreadsheet and graphics toolit contains a programming language called Visual Basic for Applications (VBA), which allows you to automate simple tasks and enables you to create full-featured applications that make Excel users even more productive. In the Definitive Guide to Excel VBA, Second Edition, veteran author Michael Kofler provides exhaustive coverage of VBA for Excel, demonstrating how it can be used to implement real-world business solutions. Designed to be useful to programmers who have never used VBA before, it also covers advanced topics needed for users already familiar with VBA. First, Kofler introduces VBA and the Excel object model, focusing on the unique characteristics of programming and debugging code associated with spreadsheets. The next few chapters cover menus, toolbars, forms, and templatesthe tools for creating customized user interfaces and full-featured applications. He then moves on to a broad range of advanced topics, including automating graphs and diagrams, accessing external databases from Excel, and analyzing data using grouping and pivot-tables. He even covers ActiveX automation and the access of Web Services using the Web Service Toolkit. Throughout the book, Kofler never loses sight of the real-world problems faced by Excel programmers. The book also explores ways to avoid undocumented problems that may arise when programming Excel VBApractical knowldege that was gained through years of hard experience.
|
| Customer Reviews: Read 12 more reviews...
 An excellent addition to any Excel Libary March 3, 2006
Michael Alexander (Frisco, Texas)
3 out of 3 found this review helpful
This book was originally published in Germany. Kudos to Apress for picking it up and translating it. The translation is the reason many have called this book cryptic. But make no mistake, this is a fantastic book that covers many things that others do not. This is a great addition to any Excel library.
 Doesn't Cover "good" VBA programming practices October 5, 2005
Erik Engbrecht
7 out of 9 found this review helpful
I like to break programming into two different categories: scripting and application development.
These categories have little to do with the programming language, and more to do with the intent and style. "Scripts" generally aren't very robust: they have minimal error handling, they don't cleanly fail when unexpected data is encountered, etc. "Applications" are supposed to be more robust.
All of the VBA programs (and programming books) I've seen are mostly focused on getting the programmer from Point A to Point B without regard to any problems that may be created along the way.
This book goes into great detail about how to automate Excel, but it does not teach you how to make an Excel "Application," nor does it provide the necessary deep details about how VBA behaves for a programmer to be able to figure it out without turning to other references, and mostly experimentation.
In short, this book teaches you how to effectively create reams of unmaintainable spaghetti code.
If you only buy one VBA book... April 26, 2005
B. W. Holcomb (Cleveland, OH)
7 out of 7 found this review helpful
If you only plan to buy one book on Excel VBA (and trust me, one may be enough for most people!), then this is it. Mr. Kofler gives a comprehensive treatment of the subject matter that is structured in a logical and progressive manner. New, intermediate, and even advanced programmers are sure to find nuggets of valuable information in these 900+ pages.
Several chapters are directly related to database applications within Excel which is a strong plus for me. I haven't found another book that covers Excel databases so it was a welcome addition.
Excellent March 15, 2004
Randy Given (Manchester, CT USA)
9 out of 12 found this review helpful
This is an excellent guide to Excel VBA. I have programmed in VB for 12+ years, but have barely dabbled in VBA. I needed to develop some tools for Excel using VBA. I asked expert friends on Experts-Exchange (www.experts-exchange.com) and Open IT (pub21.ezboard.com/bopenitforum) and they gave me three highly recommended books. I look on Amazon and came up with about five to consider, include those three previously recommended. I looked at copies of those and others and chose this book as the one most likely to fit my needs. So far, I am not disappointed.
Advanced Excel VBA Material January 2, 2004
John C. Pappas (Escondido, CA United States)
10 out of 10 found this review helpful
This is a great book for the intermediate to advanced Excel VBA user. It covers many fine details missed by other Excel VBA texts. This does NOT make this text better than others that focus on basic skills for VBA Application programming. Beginners may get lost in the depth of the details but experienced users will be very happy with the depth of knowledge that makes the difference between a good application and a great application. Buy this book after you master the fundamentals. Highly recommended.
|
|
|
Thank you for browsing ExcelBookstore.com! | |
