Message from Dean - May 8th 2007

I am currently testing out a new version of the APF Bridge Component - If you notice any errors within this demo store please drop me a line.

Binding: Paperback
Dewey Decimal Number: 005
EAN: 9780596003593
Edition: 2nd
Format: Illustrated
ISBN: 0596003595
Label: O'Reilly Media, Inc.
Manufacturer: O'Reilly Media, Inc.
Number Of Items: 1
Number Of Pages: 570
Publication Date: June 15, 2002
Publisher: O'Reilly Media, Inc.
Studio: O'Reilly Media, Inc.

---

Related Items:

• Excel 2003 Power Programming with VBA (Excel Power Programming With Vba)
• Excel VBA Programming For Dummies (For Dummies (Computer/Tech))
• Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft(R) Excel and VBA(R) (Addison-Wesley Microsoft Technology Series)
• VB and VBA in a Nutshell: The Languages
• Programming Excel with VBA and .NET
• see more

Browse for similar items by category:

• Books > Specialty Stores > Custom Stores > By Publisher > O'Reilly > Programming > General
• Books > Specialty Stores > Custom Stores > Qualifying Textbooks > General AAS
• Books > Subjects > Computers & Internet > Microsoft > Applications > Excel
• Books > Subjects > Computers & Internet > Microsoft > Applications > Office 2000
• Books > Subjects > Computers & Internet > Microsoft > Applications > Office XP

---

Editorial Review:

Product Description:
Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel. Writing Excel Macros with VBA, 2nd Edition is written in a terse, no-nonsense manner that is characteristic of Steven Roman's straightforward, practical approach. Instead of a slow-paced tutorial with a lot of handholding, Roman offers the essential information about Excel VBA that you must master to write macros effectively. This tutorial is reinforced by interesting and useful examples that solve common problems you're sure to have encountered. Writing Excel Macros with VBA, 2nd Edition is the book you need to delve into the basics of Excel VBA programming, enabling you to increase your power and productivity.




Rating: - Excellent coverage of Excel object model
There are a number books on VBA and on programming Excel with VBA. Some of these are quite good and have many useful examples. However, once one understands the basic techniques, accomplishing one's goal primarily requires detailed knowledge of the Excel object model. One can dig through the object browser and/or the Microsoft documentation for this information or use the macro recorder as a 'prototyping' shortcut, but these techniques are somewhat time consuming and are less than complete.

This book's coverage of the Excel object model is by the far the best I have seen and is well organized and through. It explains the intent of the properties and methods rather than just explaining the syntax.

The author also details various caveats about how various components within the object model operate. This is very useful. As a simple example, he explains that setting the Chart objects .HasAxis property before the Chart has any data series defined will result in a cryptic ... Read More

---

Rating: - Good reference book for experienced macro writers
This book is very helpfull to understand the objectmodel from Microsoft Excel and VBA. After reading this book it is much easier to write efficient code.

---

Rating: - A Very Good reference bool
It is a very good reference book for excel compared to many other books which do not deal with excel as deeply as this one does. A good book to have.

---

Rating: - Dull and of no practical help
This book is the equivalent of the eastern-European piano teacher I used to have when I was a kid: proper learning involves strict discipline and sufferance. If you don't read this mind-numbing book from cover to cover, you won't get anything out of it.

I usually love Oreilly books, but this one has simply been useless for me. Time and time again I open it up for help, and I never find any answer.
Actually, last time I looked up a particular topic, it essentially said "You can do it this way, but there are better ways of doing it", and gave no further information. That's what I call useless information.

---

Rating: - Decent short-hand reference
Not a bad book but it takes some work to get through the dry parts. I think that the book is decent.

---