Books

Definitive Guide to Excel VBA
Moving to VB.NET: Strategies, Concepts and Code (.NET Developer Series)
Software Development for the Qualcomm Brew Platform
Game Development with ActionScript
Database and XML Technologies: First International XML Database Symposium, XSym 2003, Berlin, Germany, September 8, 2003, Proceedings (Lecture Notes in Computer Science S.)
Formal Methods for Software Architectures: Third International School on Formal Methods for the Design of Computer, Communication and Software Systems: Software Architectures, Sfm 2003, Bertinoro, Italy, September 22-27, 2003, Advanced Lectures (Lecture Notes in Computer Science S.)
Personal Wireless Communications: IFIP-TC6 8th International Conference, PWC 2003, Venice, Italy, September 23-25, 2003, Proceedings (Lecture Notes in Computer Science S.)
Computer Algebra Systems: A New Software Toolbox for Maple
Generic Programming: Advanced Lectures (Lecture Notes in Computer Science S.)
Software Engineering for Multi-Agent Systems: Research Issues and Practical Applications: Pt. 2 (Lecture Notes in Computer Science S.)
Engineering Self-Organising Systems: Nature-Inspired Approaches to Software Engineering (Lecture Notes in Computer Science S.)
From Object-Orientation to Formal Methods: Essays in Memory of OLE-Johan Dahl (Lecture Notes in Computer Science S.)
Extreme Programming and Agile Processes in Software Engineering: 5th International Conference, Xp 2004, Garmisch-Partenkirchen, Germany, June 6-10, 2004, Proceedings (Lecture Notes in Computer Science S.)
Contributing to Eclipse: Principles, Patterns and Plugins
Self-tuning Systems: Control and Signal Processing
The Object of Java: Introduction to Programming Using Software Engineering Principles
Java Software Solutions: Foundations of Program Design
Object Oriented Software Development: Java 1.3 Update
Project Based Software Engineering
Winning with Software: An Executive Strategy
Getting Started with Computers
Java Software Solutions: Foundations of Program Design
Essentials of Elementary Social Studies:(Part of the Essentials of Classroom Teaching Series)
The Future of Software
The 8086 Microprocessor: Programming and Interfacing the PC

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R) (The Addison-Wesley Microsoft Technology Series)

Average customer rating:

Applied compendium of best practices
A great how-to book for serious Excel users
Not a book for lBeginners
Very Good not for novice VBA programmers
Excellent Tool for Programmers !

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R) (The Addison-Wesley Microsoft Technology Series)
Stephen Bullen , Rob Bovey , and John Green
Manufacturer: Addison-Wesley Professional
ProductGroup: Book
Binding: Paperback

General | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books

Qualifying Textbooks - Spring 2007 | Stores | Books

General | Software Books | Custom Stores | Stores | Software
Similar Items:

Excel 2003 Power Programming with VBA (Excel Power Programming With Vba)
Excel Advanced Report Development
Pivot Table Data Crunching (Business Solutions)
John Walkenbach's Favorite Excel Tips & Tricks
Excel VBA Programming For Dummies (For Dummies (Computer/Tech))

ASIN: 0321262506

Customer Reviews:

Applied compendium of best practices.......2007-01-23

When you search the web and most of the books around, you can find solution to your problems most of the time, but you are rarely sure it was the best way to do it and how it would fit to the rest of your code. The authors of this book are not afraid to tell what they suppose to be the best for you, along with full featured versions of code illustrating each chapter.

I found it easy to take the code from a sufficiently leveled chapter and adapt it to get just the application that I needed, knowing it would be fast, clean and complete at the same time, although I didn't understand all the details at first. Now, the book serves as a widely findable documentation for the packages that I make. Highly recommendable.

A great how-to book for serious Excel users.......2007-01-17

When picking up this book, I was an advanced Excel user. Having discovered most of its features by trial-and-error, and coming from a fairly solid programming background, I understood well the interaction between the underlying object model and the sheets appearing on the screen to end users. I have also crafted many sophisticated worksheet formulas, and explored just about every suggestion of literature such as "Excel Hacks" and "Advanced Excel Report Development".

Professional Excel Development offers ideas and tools necessary for designing full-fledged, robust Excel-based applications. It does not spend time explaining how various features work, but rather goes into detail on how to put these features to best use.

Here is what I picked up from this book, together with the authors' Excel 2003 VBA reference:
* ways to leverage Excel's built-in features to avoid excessive coding
* advanced design techniques for using Excel as a WYSIWYG interface designer
* techniques for creating custom menu bars and programming their behavior
* various means of interacting with the user and simplifying their sessions by providing guidance as to which steps need to be taken
* restricting the Excel environment to take on the appearance of a product condusive of the goal stated in previous bullet
* using VBA in conjunction with the Excel object model to create powerful object-oriented structures for spreadsheet-based applications
* programming Excel-based solutions in an executable to provide a more standalone application
* using Windows API calls to increase robustness of the application

One key feature of this book is its consistent approach. The authors maintain a consistent structure, using the same application throughout the book for their "practical example" to demonstrate new features made available through the material in each chapter. Also, the "best practices" approach provides a level of consistency that is generally desired of anywhat sophisticated applications. Useable modules are provided on the accompanying CD, ready to be used in readers' own applications.

In the beginning, the authors explain the audiences for which this book may or may not be intended. They separate these into users, power users, VBA developers, Excel developers, and professional developers. The latter three categories of users will benefit the most from this book, each in his/her own way. VBA developers will learn how to use built-in features (I think this is where I started); Excel developers will learn how to incorporate Excel-based solutions into larger applications; Professional developers will be exposed to a great variety of "best practices", optimization techniques, and various other means for developing consistency in Excel applications.

If you do not fall into the latter three categories, you might not pick up much from this book. It is not useless to you, however; you can still find many worksheet/userform design techniques, and get an introduction to the kind of power VBA-based programming can offer. Nonetheless, you may be well-advised to start off with something simpler, such as John Walkenbach's Excel Power Programming (as alluded to by the authors of this book), simply because the present book assumes a good degree of knowledge and leaves much for the reader to figure out from the fully-functional examples provided - thereby covering the ground that it does.

Overall, this book makes for a wonderful reference to the various under-the-hood features of Excel. Even if you've already encountered many of the techniques described, and could technically discover them further on your own, it is useful to have them readily available in a single collection. Very few items are left out; application design, object-oriented programming techniques, database applications, debugging techniques, Office automation, and external interop are all covered here. Professional Excel Development is a solid reference to be consulted for years to come.

Not a book for lBeginners.......2007-01-08

This is a great book for power programmers. But be aware, this book is not for those who want to learn Excel. It's just for those who know Excel and want to imrove their programming capabilities.

Very Good not for novice VBA programmers.......2006-11-04

Buy this book because you want to be able to use VBA to help you at work. I wrote a program to automatically generate and send reports via email - about 500 of them - and my boss was in awe.

You CAN develop VBA custome applications where the user can't see the underlying MS Office application, i.e., Excel for example. They use your program like any stand-alone application. COOL!!!

Excellent Tool for Programmers !.......2006-11-03

In spite of being an advanced book, difficult concepts are explained clearly and in a very simple way.

You can find a lot of advices on best practices throughout the book as well as very powerful techniques that are really useful while you develop your applications.

For an advanced VBA programmer, this book is a must.

Average customer rating:

An excellent addition to any Excel Libary
Doesn't Cover "good" VBA programming practices
If you only buy one VBA book...
Excellent
Advanced Excel VBA Material

Definitive Guide to Excel VBA
Michael Kofler
Manufacturer: Apress
ProductGroup: Book
Binding: Paperback

General | Programming | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books

General | Software Books | Custom Stores | Stores | Software
Similar Items:

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R) (The Addison-Wesley Microsoft Technology Series)
Excel 2003 Power Programming with VBA (Excel Power Programming With Vba)
Excel 2002 VBA: Programmers Reference
Microsoft Excel VBA Programming for the Absolute Beginner, 3E
Writing Excel Macros with VBA, 2nd Edition

ASIN: 1893115798

Book Description

In this book, Michael Kofler provides definitive coverage of VBA for Excel by showing 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 gives examples of the kinds of tasks that it can perform. He then introduces the Excel object model, focusing on the unique characteristics of programming and debugging code that are associated with spreadsheets. The next few chapters cover menus, toolbars, forms, and templates—the tools for creating customized user interfaces and full-featured applications. Kofler 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 Excel-related features of Office Developer, such as the development of COM Add-Ins.

Throughout the book, the author 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 VBA—practical knowldege that was gained through years of hard experience.

Download Description

Michael Kofler has written a book that serves not only as a reference, but also focuses on solutions to frequently occurring problems. Kofler introduces Excel programming, and then provides a systematic explanation of VBA and the Excel object library in a problem-solving mode. He covers all of the essential topics in Excel programming from automatically displaying different views of data to accessing databases through ADO. Compact syntax references at the end of each chapter offer the overview not provided by Microsoft's official documentation.

Customer Reviews:

An excellent addition to any Excel Libary.......2006-03-03

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.......2005-10-05

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..........2005-04-26

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.......2004-03-15

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.......2004-01-02

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.

Average customer rating:

Definitive Guide To Excel Vba No CD Rom
Michael Kofler
Manufacturer: APRESS / SPRINGER-VERLAG
ProductGroup: Book
Binding: Paperback
ASIN: B000SNSO5C

Professional Excel Development The Definitive Guide to Developing Applications Using Microsoft Excel and VBA

Average customer rating:

Professional Excel Development The Definitive Guide to Developing Applications Using Microsoft Excel and VBA
Stephen Bovey, Rob Green, John Bullen
Manufacturer: Addison-Wesley Professional
ProductGroup: Book
Binding: Paperback

Books:

Books