Writing Excel Macros with VBA, 2nd Edition | 
 enlarge | Author: Steven Roman
Publisher: O'Reilly Media, Inc.
Category: Book
List Price: $39.99
Buy Used: $8.99
You Save: $31.00 (78%)
New (27) Used (20) from $8.99
Rating:  18 reviews
Sales Rank: 113711
Format: Illustrated
Media: Paperback
Edition: 2nd
Pages: 570
Number Of Items: 1
Shipping Weight (lbs): 1.9
Dimensions (in): 9.2 x 7.2 x 1.1
ISBN: 0596003595
Dewey Decimal Number: 005
EAN: 9780596003593
ASIN: 0596003595
Publication Date: June 15, 2002
Availability: Usually ships in 1-2 business days
Shipping: Expedited shipping available
Shipping: International shipping available
Condition: Buy from the best: 4,000,000 items shipped to delighted customers. We have 1,000,000 unique items ready to ship today!
| |
| Editorial Reviews:
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. In particular, the book focuses on: - The Visual Basic Editor and the Excel VBA programming environment. Excel features a complete, state-of-the-art integrated development environment for writing, running, testing, and debugging VBA macros.
The VBA programming language, the same programming language used by the other applications in Microsoft Office XP and 2000, as well as by the retail editions of Visual Basic 6.0. The Excel object model, including new objects and new members of existing objects in Excel 2002. Excel exposes nearly all of its functionality through its object model, which is the means by which Excel can be controlled programmatically using VBA. While the Excel object model, with 192 objects, is the second largest among the Office applications, you need to be familiar with only a handful of objects to write effective macros. Writing Excel Macros focuses on these essential objects, but includes a discussion of many more objects as well. 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.
|
| Customer Reviews: Read 13 more reviews...
 A Very Good reference bool July 22, 2008
Venkata C. Byrapogu (Philadelphia, PA USA)
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.
 Dull and of no practical help April 6, 2008
Stein (San Diego, CA United States)
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.
 Decent short-hand reference January 17, 2008
Speak Easy (San Francisco)
Not a bad book but it takes some work to get through the dry parts. I think that the book is decent.
Excellent reference. March 26, 2007
L. Harrison
I program in VB & needed a reference to the Excel object model. This book is an outstanding resource!
Among the best books on Excel VBA July 6, 2006
K. Scott Proctor (Wilmington, DE USA)
9 out of 9 found this review helpful
"Writing Excel Macros with VBA" is an excellent book on the use of VBA (Visual Basic for Applications) for Microsoft Excel. Steven Roman provides a significant amount of information in a relatively short volume.
While this book is accessible to Excel users of a variety of skill levels, it is best suited to numerically-inclined and experienced users of Excel. The book offers a good introduction to the VBA programming environment and the Excel object model.
Steven Roman has written the best book on Excel VBA that I have read to date.
|
|
|
